Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
format a % field in a mail merge
I am pulling information from an Excel file with calculated % field. I am
trying to format the merged field to the real percent. I am getting it as a decimal point and know about a formulat to mulitply by 100. My problem, the formula. Please help! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
format a % field in a mail merge
Something like
{ ={ MERGEFIELD myfield }*100 \#0 } or { ={ MERGEFIELD myfield }*100 \#0.0 } to display to 1 decimal place, where - myfield is the name of the Excel column/field - both pairs of {} are trhe special field code braces that you can enter using ctrl-F9 -- Peter Jamieson http://tips.pjmsn.me.uk "Kevin" wrote in message ... I am pulling information from an Excel file with calculated % field. I am trying to format the merged field to the real percent. I am getting it as a decimal point and know about a formulat to mulitply by 100. My problem, the formula. Please help! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time format in Mail Merge field | Mailmerge | |||
Mail Merge Field-Format Incorrect | Mailmerge | |||
how do we format a numerical mail merge field | Mailmerge | |||
Please Help - Mail merge changes format of field when merged | Mailmerge | |||
How can I edit the format of a mail merge field after it has been. | Mailmerge |