Please help with Insert Merge Field Question

[Cecil Hughey]

I want to insert a currency field in several different Form Letter layouts and have it print out to the second decimal place. Problem is if the field contains a value such as 200.40, it prints out as $200.4 instead of $200.40. How can I resolve this problem and still use a merge field?

[Lee Smith]

Merge number fields can be formatted at the layout level to read as you wish.

Go to layout mode, select the merge field, go to Menu - Format - Number.

HTH

Lee

[iMarcW]

Glad to have discovered this, but it's too bad that this works only if you select the entire text block, not text within a block. So if you have a text block with several different kinds of numbers, you have to have the ones you want formatted as currency ($0.00) in a separate block from the rest of it.

Still, it beats having to manually place the $ and .00 around the number and then if someone adds the .00 during data entry, you'll have ".00.00" there.

[Vaughan]

You could create a separate calculation field that generates the format needed for each, then display these calc fields on the layout.