decimal place and merging to word doc.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
Thanks JE--could you suggest a numeric switch? I'm not too sure what form it
should take here.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number formats in exported data 1
Merge Problems 1
Numbers after decimal point excel to word mail merge 1
how do i get zeros to show after decimal point? 2
Excel Word Mail Merge 8
How do you merge a dollar amount into a word doc and keep the $? 1
Get selected word documents from user's choice and merge those documents as a single doc file 0
Decimal places in mail merge 1

Back
Top