G Guest Sep 20, 2007 #1 How do you merge Excel Data into a Word Document and keep the number format. E.G. 150,000.00. When I merge it merges as 150000
How do you merge Excel Data into a Word Document and keep the number format. E.G. 150,000.00. When I merge it merges as 150000
D David Biddulph Sep 21, 2007 #2 Two ways: There are apparently field formatting commands available in Word or in Excel use =TEXT(A1,"#,##0.00;-#,##0.00") [modifying this to suit your preferred format]
Two ways: There are apparently field formatting commands available in Word or in Excel use =TEXT(A1,"#,##0.00;-#,##0.00") [modifying this to suit your preferred format]
D Dave Peterson Sep 21, 2007 #3 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions here: http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm about half way down the page.
Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions here: http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm about half way down the page.
