General Cell Format changed to Date for all Cells


G

Guest

I recently began having a randomly occuring issue where after saving a
workbook, when I go to open it some time later (hours/days/whenever) all of
the cells which were not explicitly changed from General format to something
else have now become Date format.

When I click the tab to create a "NEW" Worksheet in one of the affected
Workbooks all of the cells in that are also set to Date format instead of
General.

With that being said, if I just open Excel by itself everything is normal
and all cells are formatted General as they should be.

This has happened to several documents of mine and so far I have had to
completely re-create them in order to fix this issue.

I have tried going through and selecting the entire worksheet and changing
the cell formatting back to General and a few times now it has reverted back
to Date. Some (not all) of the workbooks I have use data connections on the
back end and have some rather large tables and having to recreate these is
obviously not ideal.

Anyone out there have any suggestions as to what may be causeing this to
happen or how I can change the "Default" cell format back to General instead
of Date for these workbooks? Not just for the affected Worksheets but for new
worksheets as well?
 
Ad

Advertisements

G

Guest

Sorry, forgot to mention this is for Excel 2007.
ver.
Microsoft® Office Excel® 2007 (12.0.6024.5000) MSO (12.0.6026.5000)

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top