<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
Column A on my report is displaying as &quot;001&quot; but appears to be &quot;1&quot;. &nbsp;I want to use this column for a vlookup so I want to change all the values so that they are three characters zero filled.<br />
<br />
How can I do this?
</div>
</div>


Experts,

Column A on my report is displaying as "001" but appears to be "1".  I want to use this column for a vlookup so I want to change all the values so that they are three characters zero filled.

How can I do this?

Changing columns with general format in Excel from &quot;1&quot; to &quot;001&quot;

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

Changing columns with general format in Excel from &quot;1&quot; to &quot;001&quot;

Changing columns with general format in Excel from "1" to "001"