Date format in Lotus 1-2-3 files transferred to Excel 2000 (XP)

  • Thread starter Thread starter Willystu
  • Start date Start date
W

Willystu

Cannot enter any usable dates in any Lotus 1-2-3 V5 file
imported into Excell. Text, formulas, and values seem OK,
but I have not bothered to check carefully since without
usable dates these files are useless.
Any help appreciated.
 
If Transition Formula Entry is selected under Tools, Options, Transition
uncheck it. "Transition" is a euphemism for "1-2-3 version 2.x".

--
Jim Rech
Excel MVP
| Cannot enter any usable dates in any Lotus 1-2-3 V5 file
| imported into Excell. Text, formulas, and values seem OK,
| but I have not bothered to check carefully since without
| usable dates these files are useless.
| Any help appreciated.
 
Back
Top