MS Excel 2007 bug - Numbers changes to dates

Posted on 2011-04-25
Last Modified: 2012-05-11
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.
Question by:pbo1
    LVL 81

    Accepted Solution

    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?

    LVL 85

    Assisted Solution

    by:Rory Archibald
    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.

    Author Comment

    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.
    LVL 81

    Expert Comment

    by:zorvek (Kevin Jones)
    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.


    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now