Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ctay
 
Posts: n/a
Default Mergefield format

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
includepicture From URL + Mergefield Thomas Mailmerge 1 February 18th 05 09:05 AM
Outline Format Conversion Edd Formatting Long Documents 1 January 27th 05 12:31 PM
mail merge from excel that changes my format from UK to US format mark Mailmerge 0 January 21st 05 03:01 PM
Is there a template for a research paper in APA format? StanTheMan Microsoft Word Help 1 January 19th 05 02:35 AM
Maintaining the format of linked tables. James Tables 1 December 8th 04 01:30 PM


All times are GMT +1. The time now is 07:31 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"