EXCEL VBA Import CSV large numbers as text

[Roy_Excel_Island_Apps]

Hi guys!

When importing large numbers from a csv file, Excel interpreted these numbers as scientific numbers. Formatting the column doesn't help. Only when I activate the cells and Enter, the number becomes visible again. How can I solve this? Also Text to Columns trick doesn't help.

Regards, Roy

 

[Zot]

You can import as you did. Then create another sheet. Format as text. Then copy paste value to new sheet. I think this will work

 

[jkpieterse]

Use Data, From text/CSV and make sure the format of the column in question is set to text.