Microsoft Office 2007

tammy66

For some reason when I am using excel the format cells default ,rather than being general has changed to date how do I revert back to general?

Finknottle

tammy66 wrote: »

For some reason when I am using excel the format cells default ,rather than being general has changed to date how do I revert back to general?

Not tried this myself, but Google came back with this:

http://answers.microsoft.com/en-us/office/forum/office_2007-excel/excel-2007-spontaneously-formats-entire-work-book/1ae533af-ecee-41fa-866a-2590343a111d
.................................................................
by Ron Coderre
Microsoft MVP - Excel (2006 - 2010)
This bug has been posted in many forums. Apparently, the number format in the NORMAL style spontaneously changes from General to this date format ([$-409]m/d/yy h:mm AM/PM;@). This typically happens in shared workbooks, but I have seen it happen in one of my workbooks...which was not shared.

Since a change to the NORMAL style impacts every cell that has not been specifically formatted, the end result is seemingly devastating. The fix for any particular workbook, however, is relatively easy.

To resolve that issue:
• Home.Cell_Styles
...Right-click: NORMAL...Select: Modify
...Click the Format button
...Number_Tab....Category: General

To my knowledge Microsoft has not addressed this XL2007 issue via an update or patch.
.................................................................