November 10, 200322 yr Newbies 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?
November 10, 200322 yr 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
November 13, 200322 yr 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.
November 14, 200322 yr You could create a separate calculation field that generates the format needed for each, then display these calc fields on the layout.
Create an account or sign in to comment