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