Date Displays as 1/1/1904

[bluesband]

When changing the date using 3/14/1998 format, I get 1/1/1904 displaye
in the cell. The task bar appears as =3/1/2004. The date I'm tryin
to enter is 3/1/2004.

When I try to get rid of the = sign, it always returns.

Any thoughts

 

[pikapika13]

If the "=" sign is necessary, use this format:
use the MONTH, DAY, and YEAR functions.
For example... I use "=MONTH($AG7)&"/"&DAY($AG7)" for a formula in on
of my spreadsheets.

You're not getting the date that you want because you are basicall
telling Excel to calculate: "Three divided by one divided by tw
thousand four" in date format. Let me know if this helps

 

[Gord Dibben]

Tools>Options>Transition.

Uncheck both the boxes at the "Sheet Options" section of the dialog.

Also uncheck "Transition Navigation Keys"

The above are for Lotus users.

Gord Dibben Excel MVP