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
 
Ad

Advertisements

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.

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

Top