unless the figures were originally entered as '.123 when the 'Value'
will be required.
Jerry W. Lewis Wrote:
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
--
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