Numberformat2

[Bill Norris]

Am puzzled by Numberformat2, as follows. I am trying to use the same Numberformat2 parameters to handle displaying the value correctly, regardless of the original value. If value is an integer, I don't want to display any fractions, only the integer. If value has any fractions, I want to always display 2 places to right of decimal

32 will display 32 (not 32.00)
9.5 will display 9.50
9.75 will display 9.75

Do I need to test the value first to see if it is an integer, and then select the correct Numberformat2 parameters to use depending on if it is an integer or not?

 

[Erel]

Yes.
Try this:

Sub FormatValue(n As Double) As String
   If Floor(n) = n Then Return n
   Return NumberFormat2(n, 0, 2, 2, False)
End Sub

 

[luke2012]

If I wish a format like this : 00,00

Which parameter I must pass to the numberformat2 ?

 

[Erel]

Please start a new thread for this question.