| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Percentage from Excel Data
I have a field in Excel that appears in a Word mail merge as
4.4078395849056609E-2. I want it formatted as a percentage (ie. 4.41), but when I add the following switch \# ",0.00;(,0.00)" It comes out as 0.04. I don't know what other switch to try. Thanks in advance. George |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Formatting Percentage from Excel Data
Nevermind, I found it from another post.
{={MERGEFIELD Percent}* 100} Thanks "GeorgeA" wrote: I have a field in Excel that appears in a Word mail merge as 4.4078395849056609E-2. I want it formatted as a percentage (ie. 4.41), but when I add the following switch \# ",0.00;(,0.00)" It comes out as 0.04. I don't know what other switch to try. Thanks in advance. George |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail Merge Percentage some formatting correct some not | Mailmerge | |||
| Percentage format in merge from excel | Mailmerge | |||
| Merge with Percentage field looses formatting | Mailmerge | |||
| Formatting a percentage mail merge field | Microsoft Word Help | |||
| How can I scale down a document by percentage like Excel? | Microsoft Word Help | |||
Linear Mode
