merge $ data from Excell Sleepy Dennis 11/8/2008 7:15:01 PM 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)

Re: merge $ data from Excell "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/8/2008 7:57:57 PM 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[ at ]discussions.microsoft.com> wrote in message news:391A4E74-6CFB-44FB-BB14-1F9B17322D00[ at ]microsoft.com... [Quoted Text] >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)