Return the digits in reverse order
Thanks to David Hager for this original formula.
You can return the digits of a number (that has less than 15 digits) in reverse order by using an array formula.
This formula returns a text value (left aligned) to allow for any numbers that end with a zero.
This formula must be entered as an array formula using (Ctrl + Shift + Enter).
Cell "A1" contains the number 87,654,321.
Cell "A2" contains the array formula that reverses these digits.
Cell "A4" contains the binary number 101010.
Cell "A5" contains the array formula that reverses these digits. Notice that it has removed the zero from the front.
Cell "A7" contains a number that has more than 15 digits.
Cell "A8" contains the array formula that tries to reverse these digits. Notice that some rounding has taken place and that this is not exactly the same number.
If you want to reverse more than 15 digits then you will need to use the REVERSE User Defined Function.
User Defined Function
REVERSE - Returns the contents of a cell with all the characters reversed.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top