You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Add leading zeros and remove decimals from current field

posted on June 4, 2020

A customer needs to copy values entered in a currency field to another field while adding leading zeros up to 9 digits and removing the decimals.  For example, $1,500.25 would display as 000150025.  They need to be able to export the data using a Forms Report for import to another system with these requirements.  Any idea of how to accomplish this?

0 0
replied on June 5, 2020

Hi Jen,

A field calculation should suffice:

=RIGHT("000000000" & Amount*100, 9)

2 0
replied on June 5, 2020

Jim,

You are awesome. This works perfectly. Thanks for your help.

Jen

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.