From the Tools menu, choose Options
On the Transition tab, remove the check mark from 'Transition Formula Entry'
Click OK

Macdad wrote:
Thank you very much for responding Debra.

What I see in the formula bar when I select that cell: =8/25/5

When I hold the Ctrl key and type semi-colon, I see 8/25/2005 displayed in
the cell, and 8/25/2005 dsiplayed in the formula bar. When I hit <enter
the number 0.0001596 is displayed in the cell and if I pick the cell again, I
see
=8/25/2005 in the formula bar.

"Debra Dalgleish" wrote:


What do you see in the formula bar when you select that cell?

What shows in the cell if you hold the Ctrl key, and type a semi-colon,
to enter the current date?

Macdad wrote:

I am entering the date (8/25/2005) in a cell that is date-formatted.
However, once entered the cell always displays 1/1/1900 (Excel's embedded
calendar start date), i.e. it doesn't display the date I entered. How do I
get it to display teh date I entered?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html