Are you sure you're not putting an = in front of it? If you do , you will
get a number that rounds to 0. 0 in date format it 1/0/1900.
--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

?B?ZGlhYXJl?= wrote in
:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it.
Anytime I place the date 6/30/2008 into this row excel displays
"1/0/1900". I tried to recreate the problem on other tabs of the
workbook, or in new workbooks and I can't.

What in the world is going on here?