With a number in cell A1

Try this:
=SUMPRODUCT(MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1) ),1)*10^(ROW($A$1:INDEX($A:$A,LEN(A1)))-1))

Note: Since text wrap will probably impact the display, here's that formula
in sections:
=SUMPRODUCT(MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1) ),1)
*10^(ROW($A$1:INDEX($A:$A,LEN(A1)))-1))


Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

wrote in message
...
How can I reverse numbers from one cell into another? Example A1
contains 64082... B1 (I want to show) 28064. Any suggestions would be
appreciated. Thanks.