Sorry, I forgot to paste HARSHAWARDHAN. S .SHASTRI's name in to my
message... he was the creator of the original formula which I modified.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
This variation on .. formula which I posted elsewhere in this thread is
shorter and uses 2 function calls less...

=TEXT(SUM((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))* 10^(ROW(INDIRECT("1:"&LEN(A1)))-1)),REPT("0",LEN(A1)))

--
Rick (MVP - Excel)


"Glenn" wrote in message
...
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)