Home |
Search |
Today's Posts |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I use field codes to format a number into currency?
Peter - I just checked my code and I guess with all my queries out there last
Friday, I must have found the right syntax because I have the # sign in there now. Thanks so much for the clarification. I was so happy to see that it worked before I went home on Friday. Love it when things work. Again, thanks everybody for all your continued support. I don't know what I'd do without my MS Tech group. Susan May "Peter Jamieson" wrote: As posted, there is a "#" missing from your field code - you have {MERGEFIELD "Sale" \"$,0.00; ($,0.00)"} and you need {MERGEFIELD "Sale" \#"$,0.00; ($,0.00)"} Peter Jamieson http://tips.pjmsn.me.uk Susan May wrote: Doug - I just tried to do this and it didn't work. My field codes look like this {MERGEFIELD "Sale" \"$,0.00; ($,0.00)"} and it doesn't change the format of the number that I'm importing from Excel. What am I doing wrong? "Doug Robbins - Word MVP" wrote: Press Alt+F9 to reveal the field codes and insert \# "$,0.00;($,0.00)" before the closing } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Andrea" wrote in message ... I would like to format my numbers in a mail merge to be shown as Currency so with $ and 2 decimals. I know I can do this with a field code but can't get it to work. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Field codes: MergeField field RTF format problem | Mailmerge | |||
Conditional Currency/Text Field Format in Merge | Mailmerge | |||
Access currency field wont format correctly in word mail merge | Mailmerge | |||
Currency fields in Access lose th currency format whn merged why | Mailmerge | |||
How do I format a merge field as Currency or %? | Mailmerge |