- Sep 21, 2001
- 18,447
- 133
- 106
Hey all,
I have a mail merge doc I'm building for work, and I'm having a dickens of a time with it.
I have mergefields inserted from Excel that are currency and need to be formatted as such. I figured out the formatting-
{ Amount \#$#,###.00}
Problem is, I have amounts in the thousands and in the tens. That merge formatting is making it look like this:
$1,500.00
or
$ 113.50
How can I format it correctly so that the smaller numbers don't have spaces between the $ and the number?
($...13.50 where the dots are spaces,
I have a mail merge doc I'm building for work, and I'm having a dickens of a time with it.
I have mergefields inserted from Excel that are currency and need to be formatted as such. I figured out the formatting-
{ Amount \#$#,###.00}
Problem is, I have amounts in the thousands and in the tens. That merge formatting is making it look like this:
$1,500.00
or
$ 113.50
How can I format it correctly so that the smaller numbers don't have spaces between the $ and the number?
($...13.50 where the dots are spaces,
Facebook
Twitter