XL thinks you're trying to divide 12 by 31 and then divide that result by
2006. This corresponds to a fraction of 1, which number is interpreted as
equivalent to 1/1/1900 in XL logic. It is interpreted in this way because
you have your cell formatted as a date.

Just enter the date as a date, without the = sign.

Dave
--
Brevity is the soul of wit.


"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