Merging excel info into a word table

[little bee]

I have 2003 version and am trying to merge info that includes currency
amounts into a table set up in word. I have set up the columns in excel with
the currency including $ and . but when I merge the $, decimal points and any
0 after the decimal point will not show up. It reverts back to a general
number format. Help!

 

[Michael]

You refer to your process as merging, not copying and pasting, can you
describe how do you do the merging? Because if I do copy and paste either
into a table or just anywhere in the document it shows the period and the $
sign.

 

[little bee]

I am merging a large amount of information into a table set up as a mail
merge. The information in excel lists multiple columns of information and
therefore I want to merge this information into the table that I have set up
using the mail merge format. All information will merge except the columns
that I have set up as currency.