|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 4th, 2009, 03:43 PM
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
April 4th, 2009, 04:04 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
