R
RLB
Hi,
I table of 3 digit numeric fields, data in field can be 1-3 significant
digits. I use the numbers as input to another look up that requires all 3
digits and filled with zeros. So I need a formula to determine number of
significant digits in original field and if less than 3 fill to 3 with zeros.
I tried "format" as well as "precision as displayed", but niether worked.
I table of 3 digit numeric fields, data in field can be 1-3 significant
digits. I use the numbers as input to another look up that requires all 3
digits and filled with zeros. So I need a formula to determine number of
significant digits in original field and if less than 3 fill to 3 with zeros.
I tried "format" as well as "precision as displayed", but niether worked.