Previous Topic Next Topic

Excel 2007 resetting cells to Date format

Solved/Closed
ktech25 Posts 2 Registration date Thursday November 12, 2009 Status Member Last seen November 12, 2009 - Nov 12, 2009 at 11:47 PM
 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?
Related:

5 responses

Answer 1 / 5
Bob
Jan 12, 2010 at 02:57 PM
I have same problem. Seems to occur randomly and chnages format accross all sheets. Anyone have a solution as yet for this
17
User
Mar 26, 2010 at 02:06 PM
Still looking for a solution. This just happened to me.
0
Anon
May 2, 2010 at 10:40 PM
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.
0
Kiwi Dan
Jul 21, 2010 at 06:59 PM
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.
0
Spot
Aug 30, 2010 at 01:29 AM
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
0
Talwinder
Sep 22, 2010 at 04:11 AM
Thanks , it is working
0
Answer 2 / 5
BookCook
Dec 1, 2009 at 01:56 PM
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.
6
Answer 3 / 5
pro-genius Posts 185 Registration date Tuesday November 18, 2008 Status Member Last seen January 29, 2010 68
Nov 16, 2009 at 12:16 AM
Nope never saw this kind of problem, did you try to reinstall office ?
1
Answer 4 / 5
numbersgirl
Jun 9, 2010 at 11:06 AM
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.
0

Didn't find the answer you are looking for?

Ask a question
Answer 5 / 5
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 9, 2010 at 11:38 AM
Did you see and try this one.
https://ccm.net/forum/affich-198909-excel-2007-resetting-cells-to-date-format#6
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses