BullsEye!!!
Excellent!

That was great. I thank you more than I can say:)

Jaemun.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Do you want a number or text returned?

You originally stated "number" so I assumed it was a custom formatted
number
which you would re-format after reversing.

Is 11,22,33,44 a custom formatted number or is it text that Excel thinks
is a
number?

This will return 11,22,33,44 as 44,33,22,11 but as text.

Public Function RevStr(Rng As Range)
RevStr = StrReverse(Rng.text)
End Function


Gord

On Sat, 24 Dec 2005 06:13:07 +0800, "Jaemun" <x wrote:

Cool!

That was what I'm talking about (user define functions). But I want it
exactly the same.as what it have in the cell without removing the commas.

Thanks in advance.

Jaemun,

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Public Function RevStr(Rng As Range)
If IsNumeric(Rng) Then
RevStr = StrReverse(Rng.Text) + 0
Else
RevStr = StrReverse(Rng.Text)
End If
End Function


Gord Dibben Excel MVP

On Sat, 24 Dec 2005 05:30:00 +0800, "Jaemun" <x wrote:

How to the number that seperate with commas e.g. 11,22,33,44 to become
44,33,22,11 using formula functions?