date format displaying as number

  • Thread starter Thread starter Ber
  • Start date Start date
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
 
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.
 
Back
Top