Inserting decimal inbetween text / numbers

[nadzri]

Hi,
I got these from previous post.

=IF(LEN(A1)=3,LEFT(A1,1)&"."&RIGHT(A1,2))

1 = 0.01 IF(LEN(A1)=1,LEFT(A1,0)&"0.0"&RIGHT(A1,1))
22 = 0.22 IF(LEN(A1)=2,LEFT(A1,0)&"0."&RIGHT(A1,2))
333 = 3.33 IF(LEN(A1)=3,LEFT(A1,1)&"."&RIGHT(A1,2))
.
.
.
Until 10 digits.

1234567890 = 12345678.90

But the problem arise because nested 'if" can only be use up to 7 times.

What should I do to insert the decimal just by stating "To put decimal two character from the right disregard how many character it is on the left and at the same time converting it from text to numbers(value)?"

Thanks for the help.
Nadzri

 

[GlennUK]

Why don't you convert to numeric first and divide by 100?

=VALUE(A1)/100

 

[nadzri]

Gee...

I never thought of that...
Thanks a million man.

I felt so stupid now