![]() |
#2
|
||||
|
||||
![]()
The \b and \f switches don't work with other switches. Instead, you could code the mergefield as:
{ MERGEFIELD Cost \# "'$→'0.00' '; '$→'(0.00)"} or: { MERGEFIELD Cost \# "'$→'0.00; '$→'-0.00"} and use a right-aligned tab in the cell. To suppress 0 outputs, you could code the mergefield as: { MERGEFIELD Cost \# "'$→'0.00' '; '$→'(0.00);"} or: { MERGEFIELD Cost \# "'$→'0.00; '$→'-0.00;"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
dollar format, tab alignment, table cell |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to format negative values in red, right aligned but have £ sign to the left? | Jules90 | Excel | 0 | 09-18-2020 03:13 AM |
![]() |
wordnew | Word | 10 | 09-06-2020 08:23 AM |
![]() |
wheddingsjr | Excel | 3 | 07-26-2019 07:41 AM |
![]() |
krneki | Word | 3 | 08-17-2015 08:34 AM |
Merge, Too many Numbers right of the Decimal Point | ohdearme | Mail Merge | 0 | 10-25-2009 05:10 PM |