How do I use field codes to format a number into currency? Andrea 10/24/2008 8:47:02 PM 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.

Re: How do I use field codes to format a number into currency? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/24/2008 10:33:36 PM 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" <Andrea[ at ]discussions.microsoft.com> wrote in message news:23002970-AC76-492C-B739-B52305480C89[ at ]microsoft.com... [Quoted Text] > 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.

Re: How do I use field codes to format a number into currency? Annette 10/29/2008 4:29:01 PM It works!!! I've been looking for this ever since we switched to Windows XP and Office 2007. I have problems with percents, also - what would I add to the code to keep the number as a percent rather than reverting to a decimal? "Doug Robbins - Word MVP" wrote: [Quoted Text] > 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" <Andrea[ at ]discussions.microsoft.com> wrote in message > news:23002970-AC76-492C-B739-B52305480C89[ at ]microsoft.com... > > 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. > > >

Re: How do I use field codes to format a number into currency? "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 10/29/2008 4:35:56 PM See http://www.gmayor.com/formatting_word_fields.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Annette wrote: [Quoted Text] > It works!!! I've been looking for this ever since we switched to > Windows XP and Office 2007. I have problems with percents, also - > what would I add to the code to keep the number as a percent rather > than reverting to a decimal? > > "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" <Andrea[ at ]discussions.microsoft.com> wrote in message >> news:23002970-AC76-492C-B739-B52305480C89[ at ]microsoft.com... >>> 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.

Re: How do I use field codes to format a number into currency? Annette 10/29/2008 4:51:03 PM Wow...a lot of info! Let's see if I picked the correct one - I would add * 100\# "0%" before the closing }. And it looks like there's a space between * and 100, and between # and ". "Graham Mayor" wrote: [Quoted Text] > See http://www.gmayor.com/formatting_word_fields.htm > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > Annette wrote: > > It works!!! I've been looking for this ever since we switched to > > Windows XP and Office 2007. I have problems with percents, also - > > what would I add to the code to keep the number as a percent rather > > than reverting to a decimal? > > > > "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" <Andrea[ at ]discussions.microsoft.com> wrote in message > >> news:23002970-AC76-492C-B739-B52305480C89[ at ]microsoft.com... > >>> 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. > > >

Re: How do I use field codes to format a number into currency? "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 10/30/2008 6:41:58 AM It is the correct one, but you have not interpreted it correctly. Note the extra field brackets {} inserted with CTRL+F9 around the whole. This is a calculated field surrounding the mergefield. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Annette wrote: [Quoted Text] > Wow...a lot of info! Let's see if I picked the correct one - I would > add * 100\# "0%" before the closing }. And it looks like there's a > space between * and 100, and between # and ". > > "Graham Mayor" wrote: > >> See http://www.gmayor.com/formatting_word_fields.htm >> >> -- >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> Graham Mayor - Word MVP >> >> My web site www.gmayor.com >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> >> >> Annette wrote: >>> It works!!! I've been looking for this ever since we switched to >>> Windows XP and Office 2007. I have problems with percents, also - >>> what would I add to the code to keep the number as a percent rather >>> than reverting to a decimal? >>> >>> "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" <Andrea[ at ]discussions.microsoft.com> wrote in message >>>> news:23002970-AC76-492C-B739-B52305480C89[ at ]microsoft.com... >>>>> 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.

Re: How do I use field codes to format a number into currency? Annette 10/30/2008 1:11:01 PM Got it - thanks so much! "Graham Mayor" wrote: [Quoted Text] > It is the correct one, but you have not interpreted it correctly. Note the > extra field brackets {} inserted with CTRL+F9 around the whole. > This is a calculated field surrounding the mergefield. > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > Annette wrote: > > Wow...a lot of info! Let's see if I picked the correct one - I would > > add * 100\# "0%" before the closing }. And it looks like there's a > > space between * and 100, and between # and ". > > > > "Graham Mayor" wrote: > > > >> See http://www.gmayor.com/formatting_word_fields.htm > >> > >> -- > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > >> Graham Mayor - Word MVP > >> > >> My web site www.gmayor.com > >> Word MVP web site http://word.mvps.org > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > >> > >> > >> Annette wrote: > >>> It works!!! I've been looking for this ever since we switched to > >>> Windows XP and Office 2007. I have problems with percents, also - > >>> what would I add to the code to keep the number as a percent rather > >>> than reverting to a decimal? > >>> > >>> "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" <Andrea[ at ]discussions.microsoft.com> wrote in message > >>>> news:23002970-AC76-492C-B739-B52305480C89[ at ]microsoft.com... > >>>>> 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. > > >