how do I mail merge data from excel as formated lulu 6/21/2007 7:29:02 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:49:53 PM If you can't see my previous reply, let's hope you can see this version: 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:F1E5C269-856C-4AC6-9BD2-EBFD3A58CEFD[ 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