<div>
If columns are formatted as text instead of applying standard (automated) formatting, you should get the desired export result.
</div>


Developer & Coffee Roaster

Scott Fell

Software Engineer

<div>
Hi All:<br />
<br />
Yes, the Import From Text Wizard does a nice job of formatting as text.<br />
<br />
But, saving the resulting Excel spreadsheet as a .csv file strips out the leading zeroes again. &nbsp;And, if you save the resulting spreadsheet instead in .xlsx format, you no longer have a true .csv file.<br />
<br />
John
</div>


<div>
Try bringing the data in with Power Query (Get and Transform). &nbsp;Change type to &quot;Text&quot;, then load to table.
</div>


<div>
I really cannot see how Neeraj's comment &nbsp;helps to solve your issue. You told us you managed to have leading zeros on import already. Your issue is the export, and the method I told you works fine.
</div>


<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I have read articles on retaining leading zeroes in Excel comma delimited files, using the Text Import Wizard. <br />
<br />
But, doing so simply imports data into Excel. &nbsp;If you save the resulting Excel file as a comma delimited file, you still lose the leading zeroes.<br />
<br />
Is there not a way of retaining leading zeroes in comma delimited files in Excel?<br />
<br />
Thanks!<br />
<br />
John
</div>
</div>


Hi:

I have read articles on retaining leading zeroes in Excel comma delimited files, using the Text Import Wizard. 

But, doing so simply imports data into Excel.  If you save the resulting Excel file as a comma delimited file, you still lose the leading zeroes.

Is there not a way of retaining leading zeroes in comma delimited files in Excel?

Thanks!

John

If columns are formatted as text instead of applying standard (automated) formatting, you should get the desired export result.

Hi All:

Yes, the Import From Text Wizard does a nice job of formatting as text.

But, saving the resulting Excel spreadsheet as a .csv file strips out the leading zeroes again.  And, if you save the resulting spreadsheet instead in .xlsx format, you no longer have a true .csv file.

John

Try bringing the data in with Power Query (Get and Transform).  Change type to &quot;Text&quot;, then load to table.

I really cannot see how Neeraj&#39;s comment  helps to solve your issue. You told us you managed to have leading zeros on import already. Your issue is the export, and the method I told you works fine.

Excel: Maintaining Leading Zeroes in Comma Delimited Files

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.