I have a column formated as text that i need to convert to numbers.
Example: 0.01 (text format) into 0.01 (number format)
Any idea how this can be done?
Thanks
Odiseus
Convert Text To Number
-
-
-
Re: Convert Text To Number
In a cell, enter 1. Copy the cell. Select the column, Edit, Paste special, select "Multiply", enter.
HTH
Daniel -
Re: Convert Text To Number
An alternative:
Select the entire column and go Data>TextToColumns>Finish.
Richard
-
Re: Convert Text To Number
Here's an alternative that can be done by formula only. If the value is in cell A1, use this formula: =A1*1.
-
Re: Convert Text To Number
QuoteExample: 0.01 (text format) into 0.01 (number format)
Replace the Text Format with the number format you want.
-
-
Re: Convert Text To Number
Thanks for all the responses. If i do all of the above then the text "0.51" would be converted to the number 0.51 but the text "0.50" would be converted to 0.5. Is there a way for me to retain the extra 0? According to the answers I got in another thread (http://www.ozgrid.com/forum/showthread.php?t=92016) the answer would be No. So thanks a lot to all the responders.
Odiseus -
Re: Convert Text To Number
Then, for the numberformat, choose "Number" (two decimals).
Daniel -
Re: Convert Text To Number
Oh no! Not the decimal places again
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!