vb number format

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
peanut1010Asked:
Who is Participating?
 
rajsekarConnect With a Mentor Commented:
try this

Val(MID("00001230",1,6))  & "." & Val(MID("00001230",7,2))
0
 
MannSoftCommented:
You could use the FormatNumber() function.  I think maybe:

FormatNumber(TheNumber, 2, 0, 0, 0)
0
 
peanut1010Author Commented:
also if it is like this


00000012

should be 0.12
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
MannSoftCommented:
In that case, FormatNumber(TheNumber, 2, -1, 0, 0) should do it
0
 
peanut1010Author Commented:
it is putting the the numbers 1st and leaving the .0000


not

00000120

0.120

doing

120.00
0
 
GrahamSkanRetiredCommented:
Why not simply divide by 100?
0
 
peanut1010Author Commented:
because it would make it 1.2
divide by 1000 would still make it

120,000
0
 
GrahamSkanRetiredCommented:
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
0
All Courses

From novice to tech pro — start learning today.