+ Reply to Thread
Results 1 to 2 of 2

Problem - Excel is Auto Converting Numbers to Date Format

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Problem - Excel is Auto Converting Numbers to Date Format

    I've been having a problem lately with Excel automatically converting all of the cells on my spreadsheet from standard number format to dates. I've created several spreadsheets for calculations and all the cells in the number formats that I wanted. It's been saved and actually reopened and used several times. I opened it this morning and now half of numbers are now converted to dates. I've had this happen several times on several different spreadsheets. Why is this happening? Is there a setting somewhere that I need to change?

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Problem - Excel is Auto Converting Numbers to Date Format

    What you are describing can be caused by a corrupt Normal Style. From the Home tab, pull-down Cell Styles..., right click Normal and make any necessary corrections.
    Gary's Student

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1