View Single Post
  #1   Report Post  
vitality
 
Posts: n/a
Default 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


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