Excel - Text to columns prompt before opening csv file

Question

I have a number of CSV files that I open with Excel, however, when I open the CSV files I do not get the Text to Columns prompt, how do I get this to prompt before I open the csv file?

The leading zeros from cell are being removed automatically by Excel, even if I try the Text to Columns after I have open the CSV files, the leading zeros are still not appearing. I assume other formatting is taking place.

Many Thanks.

Have you opened the CSV in a text editor to confirm the original data has leading zeros? — Nick.Mc, Feb 14 '16 at 22:40

score 1 · Accepted Answer · answered Feb 14 '16 at 23:01

1

Do not open the csv's by double-clicking.

First open Excel and then use the Data Import Wizard:

answered Feb 14 '16 at 23:01

Gary's Student

95,722
10
59
99

Thanks so much. Cheers. – netraider Feb 14 '16 at 23:05

Excel - Text to columns prompt before opening csv file

1 Answers1

Linked