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