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