Mail Merge

T

Terry C

Even after I have formatted the cells in Excel (currency, $, 2 decimals),
when I try to bring that data into publisher for my mail merge, it has
multiple numbers past the decimal point, i.e instead of $125.26 it shows up
as $125.265.

Seemed to try everything and can't correct. Any suggestions<

Thanks
 
E

Ed Bennett

Terry said:
Even after I have formatted the cells in Excel (currency, $, 2 decimals),
when I try to bring that data into publisher for my mail merge, it has
multiple numbers past the decimal point, i.e instead of $125.26 it shows up
as $125.265.
Click to expand...

Save as a CSV file and merge from that. Publisher completely ignores
Excel's cell formatting, as you've found out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Mail merge not formatting numbers correctly 1
Mail merge with prices 2
Mail merge - formatting numbers 3
Inserting picture into a Publisher 2007 mail merge 1
Problem with SET & REF function 0
Formaiting a Catalogue merge 2

Top