• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 71
  • Last Modified:

Mail merge decimal places

I am using mail merge to bring data from an Excel spreadsheet into a Word document. I can do it all OK, but when I merge a number from Excel which is formatted as 3 decimal places, it merges in the Word document as a number with about 12 decimal places! What am I doing wrong?
0
BlosMusic
Asked:
BlosMusic
  • 4
  • 3
  • 2
  • +1
1 Solution
 
Rob HensonIT & Database AssistantCommented:
The Word document is pulling the raw value of the number and not the formatted version.

Easiest solution is probably to insert a column in to the Excel sheet and enter a formula rounding the value to 3 decimal places as required and then merge on that field instead.

Thanks
Rob H
0
 
Santosh GuptaCommented:
OR, click on any value see if its showing 12 deciamal points, then select row, right click and go to "format Cell" and select appropriate format for number.
0
 
BlosMusicAuthor Commented:
Hi Rob, Hi Santosh,
No, I've already done that: the cells with the numbers I am merging are already formatted to 3 d.p., and I've also copied the original cells to another cell, made that cell a 3 d.p. format, and then even copied that number to the cell I'm merging - none of that works: I still end up with a 15 or 16 (not 12 - I miscounted!) d.p. merged field in my Word doc.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Santosh GuptaCommented:
what is the extention of excel file ??

xls, xlsx or csvd somting.
0
 
Santosh GuptaCommented:
i checked with all extentions, problem is else.

Please try to change the number format of data

=TEXT(A2,"0.000")

to fix the issue.
0
 
BlosMusicAuthor Commented:
Good man! That works perfectly. Thanks very much!
0
 
Rob HensonIT & Database AssistantCommented:
I suggested sorting the number by formula not by formatting or copying. Using ROUND formula would do same as converting to text.
0
 
BlosMusicAuthor Commented:
That works too. Thanks both.
0
 
BlosMusicAuthor Commented:
I did thank everyone. This solution worked. I'm not really clear about what is meant by 'abandoning' the question. I find the system for closing something off (and awarding points or whatever you do) very opaque!
0
 
Martin LissRetired ProgrammerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now