Problem Date Formatting

[Alan S]

Hi,

I'm having a problem changing the formatting of a cell to
a date format. I have changed the format of the cell to
date... however, when a date is entered into the cell an
= apperars in front of it in the formula bar and the
result in the cell is 00-01-00.

Can anyone suggest what is going on?

Thanks in advance
Alan

 

[Alan-SouthAust]

Make sure that in the tools options transition that lotus
1-2-3 has not been checked.
What is happening is you are dividing the day by the month
by the year which will evaluate as something less than
one, and as the Excel Calendar starts from Jan 1st 1900 a
value of less than 1 means the day before.

Alan