Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
All General values changed to Date format
I have a user that has all of her spreadsheets valued suddenly changed from
General to Date format. These spreadsheet have nothing in common except that they are all used by the same user. She is using Excel 2007 on Windows XP. I checked the cell styles and Normal was set to date rather than General. I changed it back but she would not have made this change herself. I checked and there is no file in the XLStart folder in her user directory. The problem remains now. New Blank Spreadsheets open with the default set back to General and seem to be ok. However, any existing Spreadsheet seems to have been reset to the default of Date format for values. My question is twofold. 1. How could this have happened *without* her changing the normal style to date? 2. How can we reformat all of her many spreadsheets that already exist back to General easily as some actually do contain dates as well as normal 'non-date' values. (I dont want to have to open each and every SS and format cells manually). Any help is GREATLY appreciated! Thanks in advance! Frank Wood |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Names to Match Cell Values when Changed | Excel Discussion (Misc queries) | |||
Cell values have changed | Excel Discussion (Misc queries) | |||
Format changed when the details in cell changed | Excel Worksheet Functions | |||
finding values in a table using 2 criteria (changed) | Excel Worksheet Functions | |||
file format needs to be changed | Excel Discussion (Misc queries) |