Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2012, 04:20 AM
Aston Aston is offline Decimal alignment of numbers that use blank space as a thousands separator Windows XP Decimal alignment of numbers that use blank space as a thousands separator Office 2007
Novice
Decimal alignment of numbers that use blank space as a thousands separator
 
Join Date: May 2011
Posts: 15
Aston is on a distinguished road
Default Decimal alignment of numbers that use blank space as a thousands separator

Hello all,

I had to align numbers in tables today that use blank spaces as thousands separator and I couldn't use the decimal tab as I usually do with comma-separated thousands.

Example:
1 333 123
(2 777 345)

I need each digit to be aligned with the respective digit under it, regardless of the parentheses that they use to denote negative numbers.



Does anyone know how to handle this situation in a smart way without having to drag right indents for each number?

Thanks a lot in advance.
Reply With Quote
  #2  
Old 07-24-2012, 11:44 PM
macropod's Avatar
macropod macropod is offline Decimal alignment of numbers that use blank space as a thousands separator Windows 7 64bit Decimal alignment of numbers that use blank space as a thousands separator 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

Hi Aston,

You could use white commas instead of spaces, then the normal alignment tabs will work as usual.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
decimal tab, thousands separator

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal tabs with space as thousands separator harry Word 1 12-22-2023 02:59 PM
Decimal alignment of numbers that use blank space as a thousands separator Word 2010 Space Between footnote separator and note matman Word 12 05-19-2015 03:08 PM
Decimal alignment of numbers that use blank space as a thousands separator Too much space between text and footnote separator jmatthewo Word 4 05-20-2012 02:59 PM
Decimal alignment of numbers that use blank space as a thousands separator custom number format: change thousands separator Ward Excel 1 06-07-2011 08:18 PM
Decimal alignment of numbers that use blank space as a thousands separator thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:29 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