Merging excel info into a word table
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! |
Merging excel info into a word table
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. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "little bee" wrote: 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! |
Merging excel info into a word table
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. "Michael" wrote: 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. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "little bee" wrote: 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! |
All times are GMT +1. The time now is 07:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com