decimal place and merging to word doc.
 

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

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

In article ,
"elmurado" wrote:

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

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

"JE McGimpsey" wrote:

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

In article ,
"elmurado" wrote:

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

In article ,
"elmurado" wrote:

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

Take a look at the

Numeric Picture (\#) field switch

topic in Word Help