date format displaying as number

B

Ber

I have formatted my date column to dd/mm/yyyy and have typed dates in but
they display as the corrosponding number though the formula bar shows teh
date and if I double click in the cell teh date will display but as soon as I
move to another cell the number reappears what is happening??

20/12/2007 should dispaly like this but is displaying with 39436
 
D

Dave Peterson

Make sure you're not looking at formulas.

In xl2003 menus:
tools|options|view tab|uncheck formulas

Ctrl-` (control-backquote, the key to the left of the 1/! on my USA keyboard)
is the shortcut key toggle.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unable to enter date into cell which should be formatted for dates 1
Same number displaying two different dates 3
Excel is changing date format incorrectly 7
Stored date is not being recognised 1
Changing date format 2
Form Control Calendar date will not change its format 1
Excel date format YYYYMMDD 1
How to enter a date in DD-MM-YYYY format 2

Top