dates

[Frank Malone]

I click on format, cells, date, Type: 3/4/97, Ok
When I enter a date I get =8/31/92 in the formula, Excel acts like it
doesn't know its a date so puts a = sign in front of date and tries to
divide. What am I doing wrong?

 

[Jason Morin]

Don't enter the date with a "=" in front. Just enter it
as 8/31/92. Then re-format the cell if necessary.

HTH
Jason
Atlanta, Ga

 

[Jason Morin]

Keep your question in the newsgroups, please.
Go to Tools > Options > Transition tab and make sure the
box "transition formula entry" is unchecked.

 

[Frank Malone]

Thanks so much that was the problem. Can you tell me what transition formula
entry is used for. I hope unchecking it doesn't mess something else up in
worksheet.

 

[Myrna Larson]

If you are typing only what you say, i.e. 3/4/97, then go to Tools/Options,
the Transition tab, and be sure that Transition Formula Entry is NOT checked.

 

[Myrna Larson]

It's there to help Lotus converts. There may not be any left <g>.