Separate 2 last digits of a number with comma.

[ermis1975]

It must me easy....
I want to separate values in one column with comma.
e.g. 0004398 to transform 43,98

Thanks

[mdmackillop]

Is this what you're after?

=--LEFT(A1,LEN(A1)-2) & "," & RIGHT(A1,2)

[Bob Phillips]

It must me easy....
I want to separate values in one column with comma.
e.g. 0004398 to transform 43,98

Is comma the decimal separator on your machine? If so, just use


=A1/100

[ermis1975]

Thanks!!