becky wrote:
Why when I convert a spreadsheet from Lotus 123(yes I know a very
antiquated program that my company still uses)

there are happily still many users who would dispute the tag of
*antiquated* - Lotus can do most things that Excel does (with the exception
of Pivot tables) and in some cases is actually *better* than Excel.


to Excel the date must
be entered like a formula =date(year,month,day) or =date(3,8,7). If
you enter it as 08/07/03 then it comes up as 01/00/00. Can anyone
help me to correct this issue?

Thanks