Save Excel file to Lotus123 when there is no WK4 or Lotus option in the drop down

Annie S

New Member
Joined
Oct 30, 2005
Messages
25
Just started a new job and have 500+ contacts that I have in excel format. I have renamed all of the columns and was ready to import when I hit a brick wall. Unfortunately there is no option in the drop down to save the file as Lotus123 (WK4). Any options would be appreciated. Change settings etc. Thanks for being a lifesaver!
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi, you forgot to mention what version of Excel you are presently using.
Please read this: link.
 

Annie S

New Member
Joined
Oct 30, 2005
Messages
25
Thanks! Frustrating. Found a file format converter but that says it converted the file to WK4. But there is no way to actually see if it was successful and don't want to mess up the program at work unless I know it is correct. Appreciate your suggestions and input!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,329
Members
409,863
Latest member
stacy09
Top