Ascendind/descending order

[ANWAR ALAM]

Hi all! i write any number(say 69138) in cell A1. I want to display this number in both ascending order (13689) and descending order (98631) in cells B1 and C1, respectively. (1) Which formulas i should write in cells B1 and C1. (2) If i add a command button on the worksheet, then what will be the VBA CODE, behind this button for this same purpose. i shall be really grateful, if anybody can kindly help me. Thanks in anticipation and best regards!!!!!!

 

[StephenCrump]

Welcome to the Forum!

	A	B	C
1	69138	13689	98631
Sheet3

Cell Formulas
Range	Formula
B1	B1	=SUM(LARGE(0+MID(A1,N,1),N)*10^(N-1))
C1	C1	=SUM(SMALL(0+MID(A1,N,1),N)*10^(N-1))

where N: =ROW(INDIRECT("1:"&LEN(!$A1)))

I think you'll need to array-enter these formula, or use SUMPRODUCT rather than SUM for a non-array-entered formula