Entering dates

[NorthMelbourne]

Prior to an upgrade from XL97 to XL2000 I was able to enter a date such as April 8 2002 as 080402. Now XL is interpreting 080402 as 80402 (dropping the leading 0) and the formatted result is February 17 2120. Any ideas on how I might be able to enter dates without requiring separater symbols such as '/' and '-'.

Any feedback will be much appreciated.
NM

 

[Ivan F Moala]

On 2002-04-14 23:45, NorthMelbourne wrote:
Prior to an upgrade from XL97 to XL2000 I was able to enter a date such as April 8 2002 as 080402. Now XL is interpreting 080402 as 80402 (dropping the leading 0) and the formatted result is February 17 2120. Any ideas on how I might be able to enter dates without requiring separater symbols such as '/' and '-'.



Any feedback will be much appreciated.
NM

Hi NM
Your xl97 book may have had the cell formated as;

Custom > ddmmyyy

Just change the cells format to the above
ie.

Select Format > Cells > Number
Custom enter ddmmyyy