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.
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
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=473711