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. Ber wrote: > > 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 -- Dave Peterson
Thank you formula was ticked on never looked there. "Dave Peterson" wrote: > 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. > > Ber wrote: > > > > 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 > > -- > > Dave Peterson >
