View Single Post
 
Old 02-02-2021, 04:47 PM
joeu2004 joeu2004 is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

AFAIK, the only work-around is to __import__ the file instead of opening it directly.


And contrary to popular advice, you do __not__ have to rename the file to have a ".txt" extension.


In the Import Text File wizard, when you get to the last (3rd) dialog box, select the column with the long "numbers" (not!), and select Text for the Column Data Format.
Reply With Quote