Tools|Options|Transition tab
Uncheck all those Lotus 123 settings.

Excel figures that you want to do arithmetic 12 divided by 31 divided by 2006
(and formatted as a date, it's January 1st, 1900.



steve wrote:

I am using the date format of MM/DD/YYYY in a spreadsheet. I am trying to
update 12/31/2005 to 12/31/2006 and when I do so, the date comes back to me
as
01/01/1900, but the formula bar reads =12/31/2006.

How do I fix this???

Steve


--

Dave Peterson