Hoe to change text format .126 to number format 0.126

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

Assuming that your data is in column A, in B1 put

=value(A1)

and formula-copy that for the length of your data, the format 0.123 is the General format, and so should suit your needs.



Additionally, having done that, you can Copy column B and Paste Special, Values (back into column B) then delete column A.

Originally Posted by vitality

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

Changing the format does not change the underlying value. In
particular, you must do more than simply reformat to change text digits
into a number. Copy an empty cell, select the column and Edit|Paste
Special|Add.

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