F
FrankWood
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 don’t want to have to open each and every SS and
format cells manually).
Any help is GREATLY appreciated! Thanks in advance!
Frank Wood
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 don’t want to have to open each and every SS and
format cells manually).
Any help is GREATLY appreciated! Thanks in advance!
Frank Wood