Padding zeroes to a decimal field

[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

 

[HSalim]

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

 

[Marshall Barton]

I am looking for a function to pad zeroes on both sides
of the decimal.

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.