Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Bill W Bill W is offline
external usenet poster
 
Posts: 2
Default Limit the number of decimal places shown when I merge Excel-Word

I want to limit the number of decimal places displayed on a Word document
when I merge data from Excel into Word. This is testing information which
includes a person'e weight. Instead of 168.2 it shows 168.1999999999. The
weight was entered into the spreadsheet (as opposed to calculated). I have
changed the number of decimal places to display in Excel and that makes no
difference.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Limit the number of decimal places shown when I merge Excel-Word

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bill W" Bill wrote in message
...
I want to limit the number of decimal places displayed on a Word document
when I merge data from Excel into Word. This is testing information which
includes a person'e weight. Instead of 168.2 it shows 168.1999999999.
The
weight was entered into the spreadsheet (as opposed to calculated). I
have
changed the number of decimal places to display in Excel and that makes no
difference.



Reply
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
Unwanted decimal places in a mail merge from Excel Kurch Mailmerge 1 May 15th 06 10:18 PM
Limit decimal places in mail merge document Diana Corl Mailmerge 2 September 28th 05 02:13 PM
Set number of decimal places in bookmark Ray_Johnson Microsoft Word Help 2 August 25th 05 09:29 PM
Word adds extra decimal places to number fields when merging why? Mark Mailmerge 2 June 30th 05 02:47 PM
Mail merge prints out incorrect no. of decimal places from Excel . UDDWF Mailmerge 1 February 7th 05 11:22 PM


All times are GMT +1. The time now is 12:30 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"