Padding zeroes to a decimal field

S

subbu

Hi,
I am looking for a function to pad zeroes on both sides
of the decimal.Any help in this regard is highly
appreciated

subbu
 
H

HSalim

check out
FormatNumber(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit
[,UseParensForNegativeNumbers [,GroupDigits]]]])
 
M

Marshall Barton

subbu said:
I am looking for a function to pad zeroes on both sides
of the decimal.
Click to expand...

Whenever you need to display the number on a form or report,
set the text box's format property to something like
0000.00000

Use however many zeros you want on the left or the right of
the decimal point.
 
Top