Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-27-2016, 10:43 AM
RussBell RussBell is offline Windows 7 64bit Office 2016
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,647
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 10-28-2016, 05:51 AM
RussBell RussBell is offline Windows 7 64bit Office 2016
Novice
 
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
MS Word - Table allignment jbunt85 Word Tables 1 04-20-2016 02:19 AM
Text allignment - desperate! Ctonning Word 5 01-13-2016 05:11 AM
Is there a quick way to remove the dashes and parentheses from phone numbers? Stacy Excel 2 09-12-2014 07:03 AM
Parentheses Changing on Document Subject1157 Word 2 06-16-2011 08:46 PM
In vertical allignment, the dif. bettwen Justify and Distributed? Philos Hippos Excel 2 10-28-2009 10:44 AM


All times are GMT -7. The time now is 08:58 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft