PDA

View Full Version : [SOLVED] Separate 2 last digits of a number with comma.



ermis1975
09-25-2005, 02:10 PM
It must me easy....
I want to separate values in one column with comma.
e.g. 0004398 to transform 43,98

Thanks

mdmackillop
09-25-2005, 02:44 PM
Is this what you're after?

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

Bob Phillips
09-25-2005, 03:50 PM
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
09-26-2005, 05:13 AM
Thanks!!