Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting a number
I merged some data from an excel-sheet into a table in my Word-document.
In excel I have a cel with 3,4% in it. After the merge I get in Word (in the cel in my Word-table) the following: 3,4000000000E-2 With Alt+F9 I show the field: {MERGEFIELD "Percentage"} I tried to format the field as follows: {MERGEFIELD "Percentage" \#,# } That does not work. This is what I got from the help in Word. It looks like I am doing something wrong, but what? Can someone help me? Thanks, Ricky |
#2
|
|||
|
|||
See http://www.gmayor.com/formatting_word_fields.htm
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Ricky Gibson" wrote in message .. . I merged some data from an excel-sheet into a table in my Word-document. In excel I have a cel with 3,4% in it. After the merge I get in Word (in the cel in my Word-table) the following: 3,4000000000E-2 With Alt+F9 I show the field: {MERGEFIELD "Percentage"} I tried to format the field as follows: {MERGEFIELD "Percentage" \#,# } That does not work. This is what I got from the help in Word. It looks like I am doing something wrong, but what? Can someone help me? Thanks, Ricky |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different alignment formatting for header & page number on same line | New Users | |||
loss of phone number formatting when merged | Mailmerge | |||
table of contents and page number formatting | Microsoft Word Help | |||
How do I maintain number formatting in a mail merge? | Mailmerge | |||
Formatting Issue on Number Field | Mailmerge |