Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-18-2021, 02:42 PM
macropod's Avatar
macropod macropod is offline Left Leading $ with decimal aligned numbers Windows 10 Left Leading $ with decimal aligned numbers Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,385
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
 

Tags
dollar format, tab alignment, table cell



Similar Threads
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
Left Leading $ with decimal aligned numbers Rtl text aligned right and ltr text aligned to left in one line - HOW? wordnew Word 10 09-06-2020 08:23 AM
Left Leading $ with decimal aligned numbers Adding a decimal point in an already existing column of numbers wheddingsjr Excel 3 07-26-2019 07:41 AM
Left Leading $ with decimal aligned numbers Table of Contents - page numbers not aligned to the right in longer headings 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft