merge $ data from Excell

External Since: Nov 08, 2008 Posts: 1

I am trying to create statements using a list of clients in Excel 2007 and
merging the fields into a word 2007 document. I am able to merge the data
however since most of the merged data is in $ when it is merged some of it is
listed as $x.xx and some without the $ and the . How can i ensure that all
the data comes into the document as Curency ($xxx.xx)

External Since: Jul 14, 2006 Posts: 4210

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

--
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

"Sleepy Dennis" <Sleepy Dennis RemoveThis @discussions.microsoft.com> wrote in message
news:391A4E74-6CFB-44FB-BB14-1F9B17322D00@microsoft.com...
>I am trying to create statements using a list of clients in Excel 2007 and
> merging the fields into a word 2007 document. I am able to merge the data
> however since most of the merged data is in $ when it is merged some of it
> is
> listed as $x.xx and some without the $ and the . How can i ensure that
> all
> the data comes into the document as Curency ($xxx.xx)