Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text to Numeric
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
The space makes it text, so if I multiply it by a number the result is #VALUE! On Thu, 28 Jul 2005 19:02:56 +0200, "Ron de Bruin" wrote: 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 |
#4
|
|||
|
|||
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 -- Regards Ron de Bruin http://www.rondebruin.nl "lehigh46" wrote in message ... The space makes it text, so if I multiply it by a number the result is #VALUE! On Thu, 28 Jul 2005 19:02:56 +0200, "Ron de Bruin" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert text to numeric vba add-in? | Excel Worksheet Functions | |||
how do i step thru a text field looking for 6 numeric characters | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Database text converted to numeric | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |