[Sleepy Dennis]

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)

[Doug Robbins - Word MVP]

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 wrote in message
...
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)