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

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.
 
J

Jim Rech

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use Lotus 123 comands?; can I format Excel to do so? 3
Date format in imported lotus 123 file 1
Excel Lotus 1-2-3 transition for Excel 2007 1
Lotus 1-2-3 files 1
lotus 1-2-3 files 1
Help for Lotus 1-2-3 users in Excel 2003 2
What version of Excel converts Lotus 1-2-3 spreadsheets? 1
Lotus 1-2-3 file with Excel 2003 1

Top