Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5705 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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! :(

Posted (edited)

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 by Guest
Added sentence of explanation

This topic is 5705 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.