Excel 2007 resetting cells to Date format [Solved/Closed]

ktech25 2 Posts Thursday November 12, 2009Registration date November 12, 2009 Last seen - Nov 12, 2009 at 11:47 PM - Latest reply:  Archit Badwe
- Jan 30, 2013 at 01:37 PM
Hello,
I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a virus because I have ran several virus scans on my computer, but nothing and the spreadsheets changes the cells itself back to Date format.

Please Help?
See more 

11 replies

Best answer
17
Thank you
I have same problem. Seems to occur randomly and chnages format accross all sheets. Anyone have a solution as yet for this

Thank you, Bob 17

Something to say? Add comment

CCM has helped 1704 users this month

Go to custom formats and delete the custom date formats starting with a [$C-09] or something similar. This should reset all the numbers that have changed to date formats inadvertently.
I have the same problem: Out of nowhere, all of the cells in all of my sheets in this book changed to Date Format [14-Mar-01], which is not a custom date format but is a date format I use a lot, scattered through each of my sheets.

The solution above ("delete the custom date formats starting with a [$C-09] or something similar") looked to have worked for me, in that all of the numbers which were supposed to be displaying as numbers reverted back to General format. Unfortunately, all of cells that I do want to display in Date Format [14-Mar-01], are now General format and hence displaying as numbers in the 40000 range.

I guess it is safer to have everything back as General format, and I will manually have to go and return the cells I need to the date format.
Anon comment from the May 3, 2010 worked for me
Go to custom formats and delete the custom date formats starting with a [$C-09] or something similar. This should reset all the numbers that have changed to date formats inadvertently
Thanks , it is working
Thanks Anon, your solution worked
6
Thank you
FYI - To add support to the original poster - I've had the same problem. I'm an Excel expert and pretty much know all/most of the features and formats. However, there's a large spreadsheet that I open in compatibility mode where Excel has set the default format for all cells to be a date format. So if I go to an empty cell and type in "=2+3", Excel will show whatever the date equivalent is to "5" as the result in the cell. I don't think I pressed a random key combination, but it's pretty annoying/frustrating.
pro-genius 185 Posts Tuesday November 18, 2008Registration date January 29, 2010 Last seen - Nov 16, 2009 at 12:16 AM
1
Thank you
Nope never saw this kind of problem, did you try to reinstall office ?
numbersgirl - Jun 9, 2010 at 11:06 AM
0
Thank you
I'm having exactly the same problem. My workbook has 9 worksheets and they're all being converted to Date Format. Still looking for a solution.
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Jun 9, 2010 at 11:38 AM
0
Thank you
Did you see and try this one.
http://ccm.net/...