Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lotus 123 import to Excel loses 2 text characters
Everytime I attempt to import or open a Lotus 1-2-3 file in Excel (2004 Mac),
it chops the last two characters off of every cell that is interpreted as text. Ie. Jan becomes 'J', Feb becomes 'F', and numbers stored as text lose the last two digits as well. I need to convert/update a great deal of files, and cannot lose this information, please help. |
#2
|
|||
|
|||
Lotus 123 import to Excel loses 2 text characters
In Lotus can you save it as Excel, csv or xml file?
"mackie99" wrote: Everytime I attempt to import or open a Lotus 1-2-3 file in Excel (2004 Mac), it chops the last two characters off of every cell that is interpreted as text. Ie. Jan becomes 'J', Feb becomes 'F', and numbers stored as text lose the last two digits as well. I need to convert/update a great deal of files, and cannot lose this information, please help. |
#3
|
|||
|
|||
Lotus 123 import to Excel loses 2 text characters
No, the only 'save as' options in Lotus are 123 Mac, (.wk3), (.wk1), or text.
"Mike" wrote: In Lotus can you save it as Excel, csv or xml file? "mackie99" wrote: Everytime I attempt to import or open a Lotus 1-2-3 file in Excel (2004 Mac), it chops the last two characters off of every cell that is interpreted as text. Ie. Jan becomes 'J', Feb becomes 'F', and numbers stored as text lose the last two digits as well. I need to convert/update a great deal of files, and cannot lose this information, please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import plain text with formulas into Excel | Excel Discussion (Misc queries) | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Import only certain rows of a huge text file | Excel Discussion (Misc queries) | |||
Excel Save As... text with special characters | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |