Zero fill field

  • Thread starter Thread starter Marcie
  • Start date Start date
M

Marcie

I have the following calculation FormattedTotal: Format([Total],"000000000")
it takes the value 15192.3 and turns it into 000015192 I need 001519230. Can
anyone tell me what I am doing wrong?
 
FormattedTotal: Format([Total] * 100,"000000000")

It's the decimal point that's messing you up. Multiplying by 100 bumps
things past the decimal.
 
Marcie said:
I have the following calculation FormattedTotal: Format([Total],"000000000")
it takes the value 15192.3 and turns it into 000015192 I need 001519230. Can
anyone tell me what I am doing wrong?
Click to expand...


Try using:

FormattedTotal: Format([Total] * 100, "000000000")
 
I have the following calculation FormattedTotal: Format([Total],"000000000")
it takes the value 15192.3 and turns it into 000015192 I need 001519230. Can
anyone tell me what I am doing wrong?
Click to expand...

Sounds like you need to multiply 15192.3 by 100 to get 1519230, and then
format that value.
 
Back
Top