Mail merge to word

  • Thread starter Thread starter jman
  • Start date Start date
J

jman

Hello anyone, I have recently done a lawn care contract database with pricing
included. When I mail merged to my contract document in word, the numbers
from excel did NOT transpose the same. In the excell column, I do have it
marked currency with a dollar sign and two number after the decimal. However
when merged something like $45.00 only showed up as 45 and numbers that
should have rounded like $47.1287 showed this way with no dollar sign but
showed all the numbers instead of two past the decimal. $45.50 would show up
45.5 ......any help out there on this situation. Can 't get the dollar
sign to show even though coded that way in excel and and can't get a zero to
show up unless between two whole numbers and the decimal does not always show
either.
Thanks
 
Mailmerge does not recognise Excel formatting, just the real data.

You can convert the data in Excel to text values before merging.

See David McRitchie's site for how-to's

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Or Formatting can done at the Word end by formatting the fields the Excel
data is dropped into.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Excel file with Word document 6
Keeping number format when merging into Microsoft Word 2
Convert number to text as displayed 3
Currency from Excel isn't merging into a Word document properly 1
Dollar amounts aren't merging from Excel into a Word document... 3
mail merge problem 4
numerals in a mail merge 1
Using Excel values in Word Mail Merge 3

Back
Top