Excel - Text to columns prompt before opening csv file
<p>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?</p>

<p>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.</p>

<p>Many Thanks.</p>