• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

MS Excel 2007 bug - Numbers changes to dates

For some reason spreadsheets I use frequently over time for some reason change any value formatted as a number gets changed to a date value.  Has anyone else had this odd issue occur ?  What is the solution ?

This is happened on multiple spreadsheets of mine.  The only common denominator is that the spreadsheets are large and have multiple tabs.
0
pbo1
Asked:
pbo1
  • 2
2 Solutions
 
zorvek (Kevin Jones)ConsultantCommented:
When you edit the cell, what does the value look like in the formula entry box? When you select the cell and then open the Cell Format dialog, what format is selected?

Kevin
0
 
Rory ArchibaldCommented:
There seems to be an issue with Excel 2007 and some workbooks, particularly ones with lots of pivot tables or shared workbooks, whereby the Normal cell style changes its number format to Date. If you change it back to general, then hopefully your numbers should revert.
0
 
pbo1Author Commented:
zorvek, sorry on the delay.  The value looks like 15-Jun-00 in the formula bar.  The format shows as date.  Previously the format was general and the value was 15.
0
 
zorvek (Kevin Jones)ConsultantCommented:
Then it looks like what Rory suggested actually happened. You will have to change the format back to General. It's a bug. Upgrade to 2010, a more stable release, and the problem should not occur again.

Kevin
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now