| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the cell format doesn't change existing cell content
When I import data into Excel 2003, the numbers need to be reformatted so
that they can be calculated. But when I highlight the range and reformat it to a number format, it doesn't register the change. I have to click inside the cell contents (hit F2) for it to 'accept' the new format. This complicates things when there is a lot of data. Any ideas? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change format of cell content | Excel Discussion (Misc queries) | |||
| Can you lock the format of a cell and still change content | Excel Worksheet Functions | |||
| Fomula where one cell is equal to the other cell content & format | Excel Discussion (Misc queries) | |||
| Delete content of cell without erasing existing formula? | Excel Discussion (Misc queries) | |||
| automatically format cell based on content of another cell | Excel Worksheet Functions | |||
Threaded Mode
