Hi,
Excel and Word version: 2007
I have a list of numbers which display correctly in Excel - currency to 2 decimal places - though when I create the mail merge doc in Word that I need I get varying number of decimal places. How do I stop this happening - I would like to bring through the currency symbol and display to 2 dp?
If necessary I can live without the currency symbol coming through for the time being.
Unfortunately because they are invoices I am creating it isn't acceptable.
I consider myself a fairly competent user of Word and Excel but finding it frustrating to resolve this one and being my first post to the forum, I'm hoping someone can help me find a solution.
Regards
Craig
Excel and Word version: 2007
I have a list of numbers which display correctly in Excel - currency to 2 decimal places - though when I create the mail merge doc in Word that I need I get varying number of decimal places. How do I stop this happening - I would like to bring through the currency symbol and display to 2 dp?
If necessary I can live without the currency symbol coming through for the time being.
Unfortunately because they are invoices I am creating it isn't acceptable.
I consider myself a fairly competent user of Word and Excel but finding it frustrating to resolve this one and being my first post to the forum, I'm hoping someone can help me find a solution.
Regards
Craig