Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Formatting Error
I am using Windows XP SP2 with MS Office 2007. I have a spreadsheet that is
in proper condition. After working on it, I save and close the spreadsheet for later use. Upon opening the sheet at a later time, all of the cells that had a data type of "number" are now converted to data type of "date". The cells contain the correct values, however the cells display as "#####". I can convert the cell type back to "number" and the values display correctly. I cannot figure out why this is happening every time a save, close and then reopen the file. Can any one help me with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ERROR: "Unable to save data and formatting" | Excel Discussion (Misc queries) | |||
Why this error ?: Excel could not save all the data and formatting | Excel Discussion (Misc queries) | |||
Conditional formatting error | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) |