On Nov 15, 11:21 am, "Ron Coderre"
wrote:
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.- Hide quoted text -

- Show quoted text -

Just a quick add:

the difference between my (found it on the web!) formula and Rons
formula
is the 0. If you have a number like 234000 my formula would give you
000432
Rons Formula would give you 432.

If you don't need the zeros go with rons formula.

hth

Carlo