Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone number field formating | Microsoft Word Help | |||
form field,can I add a telephone number under the number field w/d | Microsoft Word Help | |||
Format a merged numeric field | Mailmerge | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help | |||
How do I insert and format part of a data field in a Word document | Microsoft Word Help |