[sccatholic]

Go back to your excel doc and retype the dollar amount using an '
(apostrophe) before each amt. ex: '$100.00 Excel will read it as
exactly what is typed (but without the apostrophe) and not try to turn it
into something different. It will then import into the Word doc as exactly
$100.00 Hope this helps. This method can be used for any data being
typed into the cell that you don't want changed (like a date).

"PPrincess" wrote:

I created a worksheet with dollar amounts and when they are merged into word,
they turn into # with 10 decimal places. I tried formating the cells in a
number of different ways.. but I just cannot get it to format correctly.
This was supposed to be the final phase in a very long project... hopefully I
can make it work!

Can anyone help me?