View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jason.Bradley Jason.Bradley is offline
external usenet poster
 
Posts: 3
Default right justify dollar amounts

So in excel numbers are formated to the right automatically which is nice,
but in word when merged, they become formated left to right. As a result I'm
getting the data in the format of:

$ 320.57
$ 5.00
$ 81,000.00

my boss however would like to see this format instead:

$ 320.00
$ 5.00
$ 81,000.00

is it possible to do this safely and easily? I assume there is some sort of
a "align right" that I can use on the field I'm merging?? Thanks! :-)