Hi All:

I have column of numbers with a space to the left.
This makes it act like text and left justified.
I removed the space from one of the numbers and it became a number and
right justified.

What formula could I use to do what I explaind above for thousands of
numbers?


x-- 100 Proof News - http://www.100ProofNews.com
x-- 30+ Days Binary Retention with High Completion
x-- Access to over 1.9 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD