<div>
MsgBox &quot;The value of Var1 is &quot;&nbsp;&amp; &nbsp;format(Var1, &quot;00&quot;) &amp;&nbsp;&quot;.&quot;
</div>


MsgBox "The value of Var1 is " &  format(Var1, "00") & "."

<div>
Thanks for the comments. &nbsp;I'd actually like to have the variable hold the 2 digit value. &nbsp;Is that possible?
</div>


Thanks for the comments.  I'd actually like to have the variable hold the 2 digit value.  Is that possible?

<div>
&gt;I'd actually like to have the variable hold the 2 digit value. &nbsp;Is that possible?<br />
Only if the variable is ultimately a string, as numeric columns/variables by default do not support leading zeros. <br />
<br />
sStringVariable = CStr(AnyNumericVariable)<br />

</div>


>I'd actually like to have the variable hold the 2 digit value.  Is that possible?
Only if the variable is ultimately a string, as numeric columns/variables by default do not support leading zeros.

sStringVariable = CStr(AnyNumericVariable)


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
&nbsp; &nbsp; &nbsp;I would like to format a sinlge digit number as a 2 digit. &nbsp;Let's say I have the following:<br />
<br />
Var1 = 1<br />
Var1 = Var1 + 2<br />
MsgBox &quot;The value of Var1 is &quot;&nbsp;Var1 &quot;.&quot;<br />
<br />
Instead of the msg displaying &quot;The value of Var1 is 3&quot;, I'd like it to display the following:<br />
<br />
&quot;The value of Var1 is 03&quot;<br />
<br />
I'm not sure how to format Var1 to always be 2 digits for single digit numbers.<br />
<br />
Thanks Experts,<br />
<br />
Jeremy
</div>
</div>


Hello Experts,

     I would like to format a sinlge digit number as a 2 digit.  Let's say I have the following:

Var1 = 1
Var1 = Var1 + 2
MsgBox "The value of Var1 is " Var1 "."

Instead of the msg displaying "The value of Var1 is 3", I'd like it to display the following:

"The value of Var1 is 03"

I'm not sure how to format Var1 to always be 2 digits for single digit numbers.

Thanks Experts,

Jeremy

Number Formatting

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.