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

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

"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



Thanks, but I did not enter the "=" sign, I entered 12/31/2006, hit enter,
and the = signed appeared in the cell by itself.

I ddn't enter the equal sign.

Steve

"Dave F" wrote:

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

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