dates in Excel 2003

VC

New Member
Joined
Feb 6, 2004
Messages
15
Does anyone know why this is happening - my dates are appearing as numbers ie 9/12/05 is displayed as 38695. This cell is formatted as dd/mm/yy and when I click on it I can see in the formula bar that it is 9/12/05 but its displays as 38695. This is happening to all my dates on this sheet. It doesn't happen in new workbooks.
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

scifibum

Well-known Member
Joined
Jul 22, 2004
Messages
503
Could you have some conditional formatting causing a problem? try clearing all formats and then reapplying the date format.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,457
Members
412,595
Latest member
slim313
Top