Entering a date displays incorrectly

  • Thread starter Thread starter gazzabj
  • Start date Start date
G

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
 
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
Click to expand...

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