decimal place and merging to word doc.

E

elmurado

We have a merged .doc which is taking its data from an excel sheet. The excel
sheet has several cells which have two d.p's
However, when some of the data from the cells are merged into the .doc they
become 3,4 or 5 d.p's
We just ant them to stay at 1.dp when they appear there.

Is this to do with the fact that excel uses doubles for storing the numbers
themselves and so they are stored at a greater d.p than is actually
displayed? And if two cells are multipled/divided do the d.p.s increase?

Thanks
 
J

JE McGimpsey

Yes, Word will see the stored value, not the displayed value. Use a
numeric switch in your Word merge doc's field(s).
 
E

elmurado

Thanks JE--could you suggest a numeric switch? I'm not too sure what form it
should take here.
 
J

JE McGimpsey

elmurado said:
Thanks JE--could you suggest a numeric switch? I'm not too sure what form it
should take here.
Click to expand...

Take a look at the

Numeric Picture (\#) field switch

topic in Word Help
 
Top