Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2016, 10:43 AM
RussBell RussBell is offline Allignment of numbers with parentheses Windows 7 64bit Allignment of numbers with parentheses Office 2016
Novice
Allignment of numbers with parentheses
 
Join Date: Oct 2016
Posts: 2
RussBell is on a distinguished road
Default Allignment of numbers with parentheses

We have a process where we mail merge numbers from a data source into a Word doc. We would like to have negative numbers in parentheses and have the far right digit before the parentheses line up with the last digit of a positive number above it. Right now, the far right bracket will only align with the far right digit above it, so it makes the alignment of the numbers on the right look uneven.

Current:
1,234,567
(890,123)

Desired format:
1,234,567
' (890,123)
Ignore apostrophe but I needed to add this in so I could get it to present properly for the purposes of this post.



Anyone know how to fix this?
Reply With Quote
  #2  
Old 10-28-2016, 01:38 AM
macropod's Avatar
macropod macropod is offline Allignment of numbers with parentheses Windows 7 64bit Allignment of numbers with parentheses Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

If you right-align the paragraph containing the mergefield, you could use a field switch coded as:
\# ",0')';(,0)"
In your mergefield, it would look like:
{MERGEFIELD MyNumber \# ",0')';(,0)"}
The trick is to format the ) in ')' with a colour the same as your page background.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-28-2016, 05:51 AM
RussBell RussBell is offline Allignment of numbers with parentheses Windows 7 64bit Allignment of numbers with parentheses Office 2016
Novice
Allignment of numbers with parentheses
 
Join Date: Oct 2016
Posts: 2
RussBell is on a distinguished road
Default

That's awesome Paul, thanks for the response.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allignment of numbers with parentheses MS Word - Table alignment jbunt85 Word Tables 1 04-20-2016 02:19 AM
Allignment of numbers with parentheses Text allignment - desperate! Ctonning Word 5 01-13-2016 05:11 AM
Allignment of numbers with parentheses Is there a quick way to remove the dashes and parentheses from phone numbers? Stacy Excel 2 09-12-2014 07:03 AM
Allignment of numbers with parentheses Parentheses Changing on Document Subject1157 Word 2 06-16-2011 08:46 PM
Allignment of numbers with parentheses In vertical allignment, the dif. bettwen Justify and Distributed? Philos Hippos Excel 2 10-28-2009 10:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 AM.


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