Problem Date Formatting

  • Thread starter Thread starter Alan S
  • Start date Start date
A

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
 
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
 
Back
Top