Mail merge to word
 

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
--
Jason

Mail merge to word
 

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

On Mon, 26 Jan 2009 07:20:10 -0800, jman
wrote:

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