Format it back to date (and choose a format to suit).
--
David Biddulph

"Airchief" wrote in message
...
I have a cell that I formatted for date. But everytime i put a date in the
block, it convert to a numerical number. For example 3-24-2007 converts
always to 39165, 3-23-2007 converts to 391164, 3-12-2007 converts to
39153.
Sorta seems like it is counting. Help!!!