Excel reversing digits
Sometimes when you are using internet marketing you need to understand difficult functions in excel to keep you one step ahead of the competition. This one entered as an array reverses the digits in a number.
=SUM(VALUE(MID(A1,ROW(INDIRECT(”1:”&LEN(A1))),1))*10^(ROW(INDIRECT(”1:”&LEN(A1)))-1))
Generally this works fine except for when number ends withn zero
Leave a comment