Lets say that the first text field is in cell A1 and they go down the
column B1, C1 and so on. I would use the column next to it to plug in
a formula. If there is no available column, insert one temporarily.
in cell A2 type =value(A1)
Just copy that formula down. You can change the formatting of the
cell but it should be a number now.
Sometimes this works. In cell A2 type =A1*1
Sometimes that will convert it to a number.
On Thu, 6 Oct 2005 05:26:48 -0500, vitality
wrote:
Hi everyone.
I has a column of data full of:
123
123
65
89
-- all in text format.
Is it possible to have some equation to change those data to:
0.123
0.123
0.65
0.89
-- as number format.
Thx
|