Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 09-15-2015, 06:10 AM
macropod's Avatar
macropod macropod is offline vba find numbers in document and align text left Windows 7 64bit vba find numbers in document and align text left Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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

You will get an almost identical visual result with:
#,##0.00_-;#,##0.00_-;"-"??_-;_-@_-
or, if you can do without the trailing space:
#,##0.00;#,##0.00;"-"??;_-@
Either of these will eliminate the space padding.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
vba find numbers in document and align text left How to either move document display to right or left; or reduce size of find/replace window. pmstock Word 2 08-02-2014 08:34 PM
vba find numbers in document and align text left Find and Replace function shooting off screen to the left of the document Mattblack Word 1 04-10-2014 03:06 PM
vba find numbers in document and align text left Align...both left and right? supersimu Word 1 01-25-2014 02:05 AM
vba find numbers in document and align text left Numbers on the left side of the text Felipe Word 2 04-19-2012 07:35 AM
vba find numbers in document and align text left How to align page to left side instead of centre ghumdinger Word 2 08-18-2011 10:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:34 PM.


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