ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Excel as data for mail merge... (https://www.excelbanter.com/excel-discussion-misc-queries/229687-using-excel-data-mail-merge.html)

dory a

Using Excel as data for mail merge...
 
How do I get my data from Excel to show only 2 decimal places in my Word
merge? I've tried to copy the excel data as values into new columns and have
also turned on the "Confirm Conversion" option in Word.

Still not able to take my currency data and show only 2 decimal places in my
merged document.

Thanks,

Dory

dory a

Using Excel as data for mail merge...
 
I found my answer a few discussions below. Sorry for the extra bandwidth.

dory

"dory a" wrote:

How do I get my data from Excel to show only 2 decimal places in my Word
merge? I've tried to copy the excel data as values into new columns and have
also turned on the "Confirm Conversion" option in Word.

Still not able to take my currency data and show only 2 decimal places in my
merged document.

Thanks,

Dory



All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com