calculation field adds leading zeros

[woodman35]

Hello:

I need to create a calculation field that takes "Field 1" adds leading 0's based adding up to 8 digits.

Must be 8 digits

Adds leading 0's

assumes two decimal points (last two digits are two decimal points)

Filed 1 Caclulation Field

1 = 00000100

1.2 = 00000120

12 = 00001200

120 = 00012000

120.50 = 00012050

Thanks for any help, I'm stumped.

JW

[Fitch]

Right( "00000000" & (Field1 * 100) ; 8 )

Make sure to specify the result as text. Number fields ignore leading zeros.

[woodman35]

Thanks sooooo much.

That Right trim part is what I was missing.

JW