| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change format of cell content
I have already prepared data sheet. I want change a column to date type for
make agraph. But can not change format of cells by right clicking. But if i double click & enter it was changed. How I change type of content. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change format of cell content
If you were changing text numbers to number numbers, you can use this technique:
Select an empty cell Edit|Copy (xl2003 menus) Select the offending range Edit|Paste special|check add and values) Dias wrote: I have already prepared data sheet. I want change a column to date type for make agraph. But can not change format of cells by right clicking. But if i double click & enter it was changed. How I change type of content. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change format of cell content
Hi,
Press key F2 in any cell and change the data. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Dias" wrote: I have already prepared data sheet. I want change a column to date type for make agraph. But can not change format of cells by right clicking. But if i double click & enter it was changed. How I change type of content. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you lock the format of a cell and still change content | Excel Worksheet Functions | |||
| change content of a given cell as different cells are indicated | Excel Worksheet Functions | |||
| how do I change the content of one cell based on another? | Excel Discussion (Misc queries) | |||
| Change the data in one cell based on content of another. | Excel Discussion (Misc queries) | |||
| content of cell change when print file | Excel Discussion (Misc queries) | |||
Linear Mode
