Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a calculated field in my Excel spreadsheet called Body Mass Index
(BMI). In the spreadsheet it is set up as a numeric field with 2 decimal places. I am merging this BMI data field into a Word document. When I excute the merge this BMI field comes into the word document with 15 decimal places. Is there some switch I can use so only 2 decimal places are displayed in my word document? Ex: Height (inches): __72__ {MERGEFIELD "Ht"} Weight (pounds): ___230__ {MERGEFIELD "Wt"} BMI % ___31.190200617283953___ {MERGEFIELD "BMI"} After the merge I want it to display ___31.19___ in the Word document. Thanks! \ Ctay |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
includepicture From URL + Mergefield | Mailmerge | |||
Outline Format Conversion | Formatting Long Documents | |||
mail merge from excel that changes my format from UK to US format | Mailmerge | |||
Is there a template for a research paper in APA format? | Microsoft Word Help | |||
Maintaining the format of linked tables. | Tables |