Actually, we don't need the VALUE function call in the formula...
=TEXT(SUM((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))* 10^(ROW(INDIRECT("1:"&LEN(A1)))-1)),REPT("0",LEN(A1)))
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
Try his formula with numbers ending in one or more zeroes... those
trailing zeroes get dropped when FLIXER'ed. Here is a modification to the
formula which preserves the trailing zeroes in the reversed number....
=TEXT(SUM(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))) ,1))*10^(ROW(INDIRECT("1:"&LEN(A1)))-1)),REPT("0",LEN(A1)))
This is still an array-entered formula, so commit it using
Ctrl+Shift+Enter and not just Enter by itself.
Note: This formula will only work for numbers having 15 digits or less.
--
Rick (MVP - Excel)
"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Dilip Pandeji,
Bahot khub.very very good.
Thanks.
H S Shastri
================================================== =======
"DILipandey" wrote:
Hello Shastri Ji..!!
Try following:-
{=SUM(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) *10^(ROW(INDIRECT("1:"&LEN(A1)))-1))}
Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
New Delhi, India
"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
================================================== =====