Solved

vb number format

Posted on 2004-04-23
8
417 Views
Last Modified: 2010-04-17
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
0
Comment
Question by:peanut1010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 6

Expert Comment

by:MannSoft
ID: 10902782
You could use the FormatNumber() function.  I think maybe:

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

Author Comment

by:peanut1010
ID: 10902783
also if it is like this


00000012

should be 0.12
0
 
LVL 6

Expert Comment

by:MannSoft
ID: 10902804
In that case, FormatNumber(TheNumber, 2, -1, 0, 0) should do it
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:peanut1010
ID: 10902863
it is putting the the numbers 1st and leaving the .0000


not

00000120

0.120

doing

120.00
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 10902888
Why not simply divide by 100?
0
 

Author Comment

by:peanut1010
ID: 10902919
because it would make it 1.2
divide by 1000 would still make it

120,000
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 10904529
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
 

Accepted Solution

by:
rajsekar earned 25 total points
ID: 10906177
try this

Val(MID("00001230",1,6))  & "." & Val(MID("00001230",7,2))
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
draw a Christmas tree by using a nested loop? 26 105
Object Oriented Programming, C#, referencing, scoping. 13 102
asp Google Map 2 92
Code planning methods/tools? 5 56
This is about my first experience with programming Arduino.
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question