<div>
Hi,<br />
<br />
pls try<br />
if you r number is in A1 and should have 5 numbers <br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41460006-1"><span>=CHAR(34)&amp;TEXT(A1,&quot;00000&quot;)&amp;CHAR(34)</span>
</code></pre>
Regards
</div>


<div>
I have actually found the problem with why I was loosing leading zeros and have been able to get this to work. &nbsp;I want to thank you for the reply. &nbsp;I have had this problem since yesterday - but it never fails when you finally give up and ask for help it seems to just work!
</div>


<div>
@jajen<br />
Glad your issue has been resolved. :)
</div>


<div>
<div class="content wysiwyg-content">
I need to take a column in Excel that has been formatted to have leading zeros and put &quot;&quot;&nbsp;around this number with a comma in between each number so I can copy these numbers into a Crystal report selection criteria. &nbsp;I can do each of the tasks separately but if I add the &quot;&nbsp;it removes the leading zero or I can add the , to get a row of these numbers but just can't find the way to successfully do all three things. &nbsp;Can someone please help me with how to successfully do this.
</div>
</div>


I need to take a column in Excel that has been formatted to have leading zeros and put "" around this number with a comma in between each number so I can copy these numbers into a Crystal report selection criteria.  I can do each of the tasks separately but if I add the " it removes the leading zero or I can add the , to get a row of these numbers but just can't find the way to successfully do all three things.  Can someone please help me with how to successfully do this.

Excel 2010 Formula

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