I'm not sure if this is the correct section to post this question, but I couldn't find a better fit (part of being a noob).

I am trying to print a MICR check field and need to take the check amount and "merge" that into a fixed layout. For instance, if the check is for $323.95 then the layout would be:

0000032395

I'm able to get the check amount to appear, but I can't figure out how to pad the left most side of the field with zeros (for a total of 10 digits).

Any help would be greatly appreciated! :(

Right ( "0000000000" & num * 100 ; 10 )

Calculation result should be text. Place this calculation on the layout or place a merge field of the calc on the layout.

Edited April 11, 200916 yr by Guest
Added sentence of explanation

Thanks!