Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-11-2013, 09:51 AM
HangMan HangMan is offline Align Mail Merged Numbers to the Decimal Point Windows 7 64bit Align Mail Merged Numbers to the Decimal Point Office 2007
Novice
Align Mail Merged Numbers to the Decimal Point
 
Join Date: Dec 2013
Posts: 5
HangMan is on a distinguished road
Default Align Mail Merged Numbers to the Decimal Point

I have a lot of numbers in a mail merge and I need to be able to align the numbers to the decimal point. I have been unable to find any way to do this. I've tried setting up the decimal tabs in my main document, but this makes no difference once the data is merged. I've tried adding a tab in my field code, but this doesn't work either.



Anyone know if this is possible without using a table and right aligning everything?

Many thanks
Reply With Quote
  #2  
Old 12-11-2013, 02:32 PM
macropod's Avatar
macropod macropod is offline Align Mail Merged Numbers to the Decimal Point Windows 7 32bit Align Mail Merged Numbers to the Decimal Point Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

A decimal or right-aligned tab-stop in the document, together with a tab between the £ and the ,0.00 in a switch coded as \# "£,0.00" should work.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you align the starting point of footnotes in multi-column format? New Daddy Word 1 11-10-2012 01:54 AM
Align Mail Merged Numbers to the Decimal Point decimal numbers not appearing properly in merged document paulys Mail Merge 2 08-06-2012 08:15 AM
Align Mail Merged Numbers to the Decimal Point Decimal alignment of numbers that use blank space as a thousands separator Aston Word 1 07-24-2012 11:44 PM
Align Mail Merged Numbers to the Decimal Point Mail Merge, Number to 2 Decimal Places Vampy99 Mail Merge 7 09-25-2011 05:41 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 12:32 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