Why when I convert a spreadsheet from Lotus 123(yes I know a very antiquated
program that my company still uses) 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
--
bb