Entering a date displays incorrectly

[gazzabj]

Hi all,

I have a Lotus spreadsheet I am converting to Excel 2000.

Some of the cells contain manually entered dates. However if I type
valid date ie

12/10/2003

Excel thinks this is a calculation and divides 12 by 10 then by 200
and then it converts it to a date?

Anyone any idea how or why this is happening and how I can stop it.

Thanks in advance

Ga

 

[Ron Rosenfeld]

Hi all,

I have a Lotus spreadsheet I am converting to Excel 2000.

Some of the cells contain manually entered dates. However if I type a
valid date ie

12/10/2003

Excel thinks this is a calculation and divides 12 by 10 then by 2003
and then it converts it to a date?

Anyone any idea how or why this is happening and how I can stop it.

Thanks in advance

Gaz

Tools/Options/Transitions and DEselect the Sheet Options
--ron

 

[gazzabj]

*On Wed, 14 Jan 2004 09:28:20 -0600, gazzabj


Tools/Options/Transitions and DEselect the Sheet Options
--ron *

Ron,

Many thanks,

thats fixed it.

Ga