Padding zeroes to a decimal field

  • Thread starter Thread starter subbu
  • Start date Start date
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
 
check out
FormatNumber(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit
[,UseParensForNegativeNumbers [,GroupDigits]]]])
 
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.
 
Back
Top