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
|