Why all the cells format on my worksheet change to date automatica

  • Thread starter Thread starter Eddie
  • Start date Start date
E

Eddie

I am using Excel 2007. I have a worksheet filled up with some number,
currency and date. It was working fine all this while. Just recently, when I
open that file. All the cells format change to date format. This is included
blank columns or rows. Its screw up all the data...

May I know why is it happen and how to rescue my file?

Thank you
Eddie
 
I'd check the Normal Style.

Home tab|styles group|cell styles dropdown icon

Make sure that the number format is General.
 
Make the check that Dave Peterson recommended.

Can you manually change the data back to the correct types? If you can,
then you can first choose all cells and change their data type to General and
begin the tedious task of changing what you currently have to the proper data
types. You haven't actually lost your data, just the way it appears, so
changing the format will get things back to the way you need them to be.
 

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

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Default Cell Format Changed? 5
Remove date format? 3
Excel Format Problem - Date Overrides Format 5
date format will not change in Excel 3
Default Cell format of existing Worksheets got changed automatical 1
How 2 change date in 1 cell/worksheet so it changes in all workshe 2
Cell requires double click to 'activate' date format change 3

Back
Top