ANWAR ALAM
New Member
- Joined
- Mar 26, 2021
- Messages
- 18
- Office Version
- 2010
- Platform
- Windows
Hi all! I am Using Excel 2010. 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!!!!!!