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 |