Home |
Search |
Today's Posts |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Format Mergefield Decimal Values
Missed a quote there - should be {MERGEFIELD "GBP_Int" \# ",0.00"}
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Graham Mayor wrote: You don't need a conditional field for this. {MERGEFIELD "GBP_Int" \# ",0.00} will do the job. Cooz wrote: Hi malycom, Use an IF field to check whether the value 1, like this: { IF {MERGEFIELD "GBP_Int"} 1 {MERGEFIELD "GBP_Int"\#"#,##0.00} {MERGEFIELD "GBP_Int"\#"#,###.00} } {MERGEFIELD "GBP_Int"\#"#,##0.00} will be used with values 1, and {MERGEFIELD "GBP_Int"\#"#,###.00} will be used with other values. Success, Cooz Hi I have a merge document which brings in values which I have formatted in this way {MERGEFIELD "GBP_Int"\#"#,###.00} This brings the data in fine, but what I now need to know is, how do I format the merge field so that if the value of the data is under 1, I get a value starting with 0. For instance, I am currently getting 91 pence showing as .91 instead of 0.91 Any help with this is greatly appreciated. Thanks in advance Malcolm Davidson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recurring decimal format | Microsoft Word Help | |||
MERGEFIELD - Numeric Picture - Insert decimal | Mailmerge | |||
formatting from a database in Word 2003 | Mailmerge | |||
Merging dollar values into word document - how to format? | Mailmerge | |||
"Char" is shown in Format list as para format for ALL styles. | Microsoft Word Help |