How about this?

=RIGHT(REPT("0",99)&SUMPRODUCT(10^(LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1)))-1),
MID(A1,LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1))),1)+0),LEN(A1))


Bernie Deitrick wrote:
That fails when there are two or more final zero digits

HTH,
Bernie
MS Excel MVP


"Glenn" wrote in message ...
Glenn wrote:
HARSHAWARDHAN. S .SHASTRI wrote:
What i need is "FLIXER" Value.

FLIXER value means reverse digit.

i e FLIXER value of 123 will be 321 , FLIXER value of 12121212 will be

21212121 like that.

Awaiting quick response.

H S Shastri

================================================== =====




This might work for you...

http://tinyurl.com/awmk88
Modified to allow a 0 for the last/first digit, but resulting in text:

=IF(MOD(A1,10)=0,"0","")&SUMPRODUCT(10^(LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1)))-1),MID(A1,LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1))),1)+0)