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


--
vitality
------------------------------------------------------------------------
vitality's Profile: http://www.excelforum.com/member.php...o&userid=27267
View this thread: http://www.excelforum.com/showthread...hreadid=473712

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

An alternate approach is given under your post in
microsoft.public.excel.misc. Please do not separately post the same
question to multiple newsgroups.

Jerry

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