<div>
It sound like the column contains numeric data but is formatted as text. &nbsp;If this is the case I would do the following:<br />
<br />
1) Highlight all the data in the column and use the Replace function to replace commas with nothing.<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/07_w30/862142/EE-replacecommas.jpg" target="_blank" title="remove commas (26 KB)"><img alt="remove commas" class="file-block lazyload" style="max-width: 457px;" data-src="https://filedb.experts-exchange.com/incoming/2014/07_w30/862142/EE-replacecommas.jpg" /></a>2) Highlight all the data, click on the alert icon, and then select &quot;Convert to Number&quot;<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/07_w30/862141/EE-ConvertToNumber.jpg" target="_blank" title="convert to number (33 KB)"><img alt="convert to number" class="file-block lazyload" style="max-width: 353px;" data-src="https://filedb.experts-exchange.com/incoming/2014/07_w30/862141/EE-ConvertToNumber.jpg" /></a><br />
Regards,<br />
-Glenn
</div>


It sound like the column contains numeric data but is formatted as text.  If this is the case I would do the following:

1) Highlight all the data in the column and use the Replace function to replace commas with nothing.
remove commashttps://filedb.experts-exchange.com/incoming/2014/07_w30/862142/EE-replacecommas.jpg2) Highlight all the data, click on the alert icon, and then select "Convert to Number"
convert to numberhttps://filedb.experts-exchange.com/incoming/2014/07_w30/862141/EE-ConvertToNumber.jpg
Regards,
-Glenn

EE-replacecommas.jpg

EE-ConvertToNumber.jpg

<div>
Thanks Glenn. &nbsp;Seems to work after I enter the correct columns and fix the range to what I need.
</div>


Thanks Glenn.  Seems to work after I enter the correct columns and fix the range to what I need.

<div>
<div class="content wysiwyg-content">
In an Excel spreadsheet, using VBA or any other script, I would like to remove leading zeros in field in a specific column, and I would also like to replace commas with nothing.
</div>
</div>


In an Excel spreadsheet, using VBA or any other script, I would like to remove leading zeros in field in a specific column, and I would also like to replace commas with nothing.

How can I automate the removal of leading zeros and commas in Excel fields?

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

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.