vba find numbers in document and align text left

peligroso · #10 09-15-2015, 05:29 AM

Quote:

Originally Posted by Guessed

Paul
On my machine, cells formatted as 'Accounting' brings a leading space into Word with an ordinary paste.

I remember having seen other cell formats that also bring multiple leading spaces but I believe this didn't happen with left aligned text.

Hi guessed,

I just checked, the current format is custom -> -* #,##0.00_-;-* #,##0.00_-;_-* "-"??_-;_-@_-

I'll try a few scenarios changing the format to see what happens.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Find and Replace function shooting off screen to the left of the document	Mattblack	Word	1	04-10-2014 03:06 PM
Align...both left and right?	supersimu	Word	1	01-25-2014 02:05 AM
Numbers on the left side of the text	Felipe	Word	2	04-19-2012 07:35 AM
How to align page to left side instead of centre	ghumdinger	Word	2	08-18-2011 10:15 AM