Excel Dates showing incorrectly

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Gogs

Thread Starter
Joined
Jul 28, 2003
Messages
121
Hya folks,

Posting this on behalf of a colleague. She has a spreadsheet set up which includes dates. She "doesn't know what she's done" but all of the dates are showing in numerical form ie: 36790 instead of date format ie. dd/mm/yy.

Excel shows the number in the cell but in the formula bar it shows the date correctly. I've tried changed the format of the cell (and even the whole sheet) to Date - dd/mm/yy but still to no avail. I've also made sure the regional settings for the PC are correct in case that was throwing it out. Even checked it's not using the 1904 date system.

Yesterday the spreadsheet was working fine but today kaput!!

Any help greatly appreciated.

Gogs
 
Joined
Aug 30, 2003
Messages
2,702
Try hitting the key below ESC while holding down CTRL.

Or use Format Painter to copy from a correctly formatted cell, in another file if necessary.

If still stuck, PM me to arrange sending a chunk of the file.

Rgds,
Andy
 
Joined
Feb 14, 1999
Messages
11,746
First Name
Anne
Have her put a 1 in any other cell. Copy it.
Choose the cells with bad dates.
Hit Edit-Paste special, Choose Multiply. Ok.

NOW, format again as mm/dd/yyyy or whatever.

It could be that Excel is seeing the numbers as text, and this should force seeing the numbers as numbers, which are formattable as dates.
 

Gogs

Thread Starter
Joined
Jul 28, 2003
Messages
121
Thank you both for the advice. I tried Andy's first and it worked. :)

Gogs
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top