Oh - If you can have 0 as the last digit, then you need to drop the VALUE wrapper and live with a
string.

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
This handles up to eight digits: I hope you can see the pattern to expand it for more....

=VALUE(LEFT(MOD(A1,10) & MOD(INT(A1/10),10) & MOD(INT(A1/100),10) & MOD(INT(A1/1000),10) &
MOD(INT(A1/10000),10) & MOD(INT(A1/100000),10) & MOD(INT(A1/1000000),10) &
MOD(INT(A1/10000000),10),LEN(A1)))

HTH,
Bernie
MS Excel MVP


"HARSHAWARDHAN. S .SHASTRI" wrote in message
...

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

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