<div>
You can preserve it by forcing it to be treated as alpha rather than numeric...<br />
<br />
Do this by editing the text file with a quote (&quot;) prior to the field...<br />
<br />
I presume this is probably a zip-code? Not that it matters!
</div>


You can preserve it by forcing it to be treated as alpha rather than numeric...

Do this by editing the text file with a quote (") prior to the field...

I presume this is probably a zip-code? Not that it matters!

<div>
No, its just data in a notepad. But when it opens as a CSV it loses the leading zeros. <br />
<br />
How can i introduce the (&quot;) to the field, where is this enetered?<br />
<br />
Thanks
</div>


No, its just data in a notepad. But when it opens as a CSV it loses the leading zeros.

How can i introduce the (") to the field, where is this enetered?

Thanks

<div>
<div class="content wysiwyg-content">
Hi, i have a text file where the leading zero is being dropped when i open using excel.<br />
<br />
Is there anyway to preserve the zero?<br />
<br />
Thanks<br />
Seamus
</div>
</div>


Hi, i have a text file where the leading zero is being dropped when i open using excel.

Is there anyway to preserve the zero?

Thanks
Seamus

Losing zeros opening a CSV file

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