Need fixed number of decimal places...zero filled 2

[patrussell]

I have an application that requires numbers to be displayed with a fixed number of decimal places, regardless of the number entered. For example, 5.123 would display as 5.12300. I have not been able to find anything that helps with doing this. Thanks for your help and time.

Pat Russell

 

[gusset]

formatnumber(5.123, 5)

the full syntax is this:
FormatNumber(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

gusset

 

[ADoozer]

have you tried format?

Private Sub Command1_Click()

Dim MyNum As Double

MyNum = 5.123

Label1.Caption = Format(MyNum, "#.00000&quot

End Sub

good luck!

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------

http://www.climateprediction.net/index.php

come on... get involved!
To get the best response to a question, please check out FAQ222-2244 first
A General Guide To Excel in VB FAQ222-3383

 

[patrussell]

Thanks ADoozer! That did the trick.

Pat Russell

 

[CCLINT]

patrussell,

Just a question, which may not even pertain to your situation:

What should happen with a number like 5.123005 ?
Should it round up (5.12301), or not round at all?

If it is not to round at all, then use:

Text1.Text = Format$((Int(TheNumber * 10 ^ 5) / 10 ^ 5), "0.00000&quot