Use this
=A1*1

Add-in solution :
DateRefiner have a option to insert a column with formulas for you
http://www.rondebruin.nl/datarefiner.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"lehigh46" wrote in message ...
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