Text to Numeric

[lehigh46]

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

 

[Ron de Bruin]

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

 

[lehigh46]

The space makes it text, so if I multiply it by a number the result is
#VALUE!

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

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

 

[Ron de Bruin]

If you have a cell that is formated as text

And enter
space123 in it you can use my formula to make it the number 123
Maybe there are other things in the cell

You can this Add-in to check your cells
http://www.cpearson.com/excel/CellView.htm