Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Using Mergefield - Convert Negative Number into Positive Number
Currently bring data into word from a database to populate invoice reminder
letters, the problem is the 'Payment Outstanding' field in my database is a Negative number. Displayed -10,000.00 for example. Instead of spending time amending the fields and updating the database I was hoping to use MergeField to do it for me.... I currently use { MERGEFIELD PaymentOutstanding\# #,##0.00} to merge the data into word, which would display -10,000.00 in the word field Any ideas how I can convert '-10,000.00' into '10,000.00' |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Using Mergefield - Convert Negative Number into Positive Number
Hi duttonkj,
There are various ways of doing this. For example, you could embed the mergefield in a formula field and multiply the mergefield value by -1: {=-{MERGEFIELD PaymentOutstanding) \# "$,0.00"} Another way is to use a field switch: {={MERGEFIELD PaymentOutstanding \# "'-'$,0.00;$,0.00"} The first approach leaves a the formula field in the document, whilst the second leaves only the calculated result. -- Cheers macropod [Microsoft MVP - Word] "duttonkj" wrote in message ... Currently bring data into word from a database to populate invoice reminder letters, the problem is the 'Payment Outstanding' field in my database is a Negative number. Displayed -10,000.00 for example. Instead of spending time amending the fields and updating the database I was hoping to use MergeField to do it for me.... I currently use { MERGEFIELD PaymentOutstanding\# #,##0.00} to merge the data into word, which would display -10,000.00 in the word field Any ideas how I can convert '-10,000.00' into '10,000.00' |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Using Mergefield - Convert Negative Number into Positive Number
Hi duttonkj,
There are various ways of doing this. For example, you could embed the mergefield in a formula field and multiply the mergefield value by -1: {=-{MERGEFIELD PaymentOutstanding) \# "$,0.00"} Another way is to use a field switch: {={MERGEFIELD PaymentOutstanding \# "'-'$,0.00;$,0.00"} The first approach leaves a the formula field in the document, whilst the second leaves only the calculated result. -- Cheers macropod [Microsoft MVP - Word] "duttonkj" wrote in message ... Currently bring data into word from a database to populate invoice reminder letters, the problem is the 'Payment Outstanding' field in my database is a Negative number. Displayed -10,000.00 for example. Instead of spending time amending the fields and updating the database I was hoping to use MergeField to do it for me.... I currently use { MERGEFIELD PaymentOutstanding\# #,##0.00} to merge the data into word, which would display -10,000.00 in the word field Any ideas how I can convert '-10,000.00' into '10,000.00' |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to underline the negative number () but exclude the last ) | Tables | |||
Display Negative Value as Positive | Mailmerge | |||
Keeping negative number end of line together | Microsoft Word Help | |||
Alignment of bracketed negative nos. with positive nos. in table | Tables | |||
How do I align table cells with positive & (negative) bracketed #' | Tables |