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)