| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel converted numbers to dates suddenly in All Sheets!!!!
Hello
I saved a file which includes records in Number Formats. Then I closed it. Next time when I opened the file All Numbers were changed to Date Format. {God!!!!!!} Why did this happens? How can I make the changes back? Some of the Cells must be in Text format and some in Date format and some in Number format That is why I can't select the whole spreadsheet and make change format to Numbers. Do I have to change each cell format manually. My Excel is 2007 but my freinds also with 2003 had similar problem. This was the first time I saw this. Thanks BHR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format has suddenly changed in all new spread sheets | Excel Discussion (Misc queries) | |||
| How do I get numbers converted to cost? | Excel Discussion (Misc queries) | |||
| I can't type whole numbers in excel they get converted to .000 | Excel Discussion (Misc queries) | |||
| SUDDENLY I CANT input numbers in excel 2003 only letters | Excel Discussion (Misc queries) | |||
| How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) | |||
Threaded Mode
