<div>
You could use the FormatNumber() function. &nbsp;I think maybe:<br />
<br />
FormatNumber(TheNumber, 2, 0, 0, 0)<br />

</div>


You could use the FormatNumber() function.  I think maybe:

FormatNumber(TheNumber, 2, 0, 0, 0)


<div>
also if it is like this<br />
<br />
<br />
00000012<br />
<br />
should be 0.12
</div>


also if it is like this


00000012

should be 0.12

<div>
In that case, FormatNumber(TheNumber, 2, -1, 0, 0) should do it
</div>


In that case, FormatNumber(TheNumber, 2, -1, 0, 0) should do it

<div>
it is putting the the numbers 1st and leaving the .0000<br />
<br />
<br />
not <br />
<br />
00000120<br />
<br />
0.120<br />
<br />
doing<br />
<br />
120.00<br />

</div>


it is putting the the numbers 1st and leaving the .0000


not

00000120

0.120

doing

120.00


<div>
Why not simply divide by 100?
</div>


<div>
because it would make it 1.2<br />
divide by 1000 would still make it<br />
<br />
120,000
</div>


because it would make it 1.2
divide by 1000 would still make it

120,000

<div>
Private Sub Command1_Click()<br />
&nbsp; &nbsp; Dim Samples As Variant<br />
&nbsp; &nbsp; Dim i As Integer<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Samples = Array(&quot;00001230&quot;, &quot;00231232&quot;, &quot;00000012&quot;)<br />
&nbsp; &nbsp; For i = 0 To UBound(Samples)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Debug.Print Format$(Samples(i) / 100, &quot;0.00&quot;)<br />
&nbsp; &nbsp; Next i<br />
End Sub<br />

</div>


Private Sub Command1_Click()
    Dim Samples As Variant
    Dim i As Integer
   
    Samples = Array("00001230", "00231232", "00000012")
    For i = 0 To UBound(Samples)
        Debug.Print Format$(Samples(i) / 100, "0.00")
    Next i
End Sub


<div>
<div class="content wysiwyg-content">
I have a number that looks like this<br />
<br />
<br />
00001230<br />
<br />
what I need is a code that will format it like this<br />
<br />
<br />
12.30<br />
<br />
now sometimes the number will be<br />
<br />
00231232<br />
<br />
should be <br />
2312.32<br />
<br />
meaning always two on the right and 4 on the left<br />
<br />
any ideas<br />

</div>
</div>


I have a number that looks like this


00001230

what I need is a code that will format it like this


12.30

now sometimes the number will be

00231232

should be 
2312.32

meaning always two on the right and 4 on the left

any ideas


vb number format

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.