how do I mail merge data from excel as formated lulu 6/21/2007 7:15:00 PM I have a very large spreadsheet I am trying to merge into a word document. When I merge, all of my dollar amount come up with no $ sign, no thousand separater, and either no ending zeros, or more than 2 decimal places. I am not sure what to do. I am in a real time bind, if anyone can help. thanks, Lulu

Re: how do I mail merge data from excel as formated "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/21/2007 7:26:12 PM See http://tips.pjmsn.me.uk/t0003.htm , but you probably only need to follow the instructions for the DDE option. Peter Jamieson "lulu" <lulu[ at ]discussions.microsoft.com> wrote in message news:956F867E-7E86-4FC1-94FB-02B01D2E469E[ at ]microsoft.com... [Quoted Text] >I have a very large spreadsheet I am trying to merge into a word document. > When I merge, all of my dollar amount come up with no $ sign, no thousand > separater, and either no ending zeros, or more than 2 decimal places. I > am > not sure what to do. I am in a real time bind, if anyone can help. > thanks, > Lulu

Re: how do I mail merge data from excel as formated lulu 6/21/2007 7:56:01 PM Peter. IT WORKED!! Thanks so very much, appreciate you quick assistance. "Peter Jamieson" wrote: [Quoted Text] > See http://tips.pjmsn.me.uk/t0003.htm , but you probably only need to follow > the instructions for the DDE option. > > Peter Jamieson > "lulu" <lulu[ at ]discussions.microsoft.com> wrote in message > news:956F867E-7E86-4FC1-94FB-02B01D2E469E[ at ]microsoft.com... > >I have a very large spreadsheet I am trying to merge into a word document. > > When I merge, all of my dollar amount come up with no $ sign, no thousand > > separater, and either no ending zeros, or more than 2 decimal places. I > > am > > not sure what to do. I am in a real time bind, if anyone can help. > > thanks, > > Lulu > >