Merging between word & excel my numbers not rounding correctly

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

Guest

I have a document in Word that I am using a spreadsheet in Excel to populate.
But, although I have the numbers in my Excel spreadsheet set up to round to
four places, when it merges that cell to Word, it is giving it 10 places.
 
You are probably not rounding, but formatting to 4 decimal places. Formatting keeps the complete accuracy and that's what gets
transferred to Word.
One way: use =TEXT(YourNumber,"#,##0.0000") or a similar format. That makes it text (as the name suggests) and will be transferred
as such to Word.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have a document in Word that I am using a spreadsheet in Excel to populate.
| But, although I have the numbers in my Excel spreadsheet set up to round to
| four places, when it merges that cell to Word, it is giving it 10 places.
 

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

Using Excel values in Word Mail Merge 3
Format Number Outlook Merge 1
Losing cell formatting as a result of a mail merge 5
Mail Merge Formating Issues 3
Mail Merge issue 4
Merge Docunent 2
Dollar amounts aren't merging from Excel into a Word document... 3
Word/Excel Integration Problem 2

Back
Top