Reply
 
Thread Tools Display Modes
  #1   Report Post  
Maui Time Jen
 
Posts: n/a
Default How do i format how a number field displays?

In my excel doc that is the merge source i have a series of data that is a
number like 9.27, 9.28, 9.29. They are not formulas. When i merge the data it
comes in as 9.27000000000, 9.2800000000000, etc. How do i get these numbers
to appear in the merge doc as just a two decimal number? I am trying to use
the switches with no success. When i add a numchar switch i get a series of
random numbers like 38, 39, 110. That has nothing to do wiht the merged data.
  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Maui Time Jen wrote:
In my excel doc that is the merge source i have a series of data that
is a number like 9.27, 9.28, 9.29. They are not formulas. When i
merge the data it comes in as 9.27000000000, 9.2800000000000, etc.
How do i get these numbers to appear in the merge doc as just a two
decimal number? I am trying to use the switches with no success. When
i add a numchar switch i get a series of random numbers like 38, 39,
110. That has nothing to do wiht the merged data.



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
Phone number field formating macropod Microsoft Word Help 3 March 26th 05 08:17 AM
form field,can I add a telephone number under the number field w/d redwolfe5 Microsoft Word Help 3 March 3rd 05 05:30 PM
Format a merged numeric field Hema Mailmerge 1 December 8th 04 12:51 AM
Text Form Field Ref in Footer Won't Update on Screen StarWine Microsoft Word Help 3 December 6th 04 06:17 PM
How do I insert and format part of a data field in a Word document Graham Blundell Microsoft Word Help 4 December 1st 04 02:51 PM


All times are GMT +1. The time now is 07:06 AM.

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"