Mailmerge numbers from Excel to Word (labels) without all decimals

H

Henrik Notlev

I have an excel spreadsheet with a prices i colum A and prices - 5% in column B

A B
13,50 12,83 (Column B shows only 2 decimals using ROUND - B is 12,825)

When I merge with labels in Word it keeps using all decimals instead of only
2.
What can I do?
Is the job in Excel or in Word?

My problem is urgent, so I hope for a quick reply.
 
H

Henrik Notlev

When setting the collumn to Text or Standard, I lose the fixed 2 decimals.
I need the collumn to write 12,00 as wall as 12,35. When using text or
standard,
it writes 12 instead of 12,00
 
B

Bob I

Well, WHICH way do you want it?!?!?

Henrik said:
When setting the collumn to Text or Standard, I lose the fixed 2 decimals.
I need the collumn to write 12,00 as wall as 12,35. When using text or
standard,
it writes 12 instead of 12,00

:
Click to expand...
 
H

Henrik Notlev

The Problem is solved.

I got a link to an article from a Microsoft girl.
The article suggested that I used ALT+F9 on the Mergefield in Word and added
\#.###,## to the Fieldcodes.
That solved the problem.

Thanks to everyone taking time to try to help me.
This was my first visit at MS Discussion groups, but not my last.
 
Top