how do you reverse the orders of numbers?
I see you will end up with leading zeros, and you presumably want to
keep these. If your first number is in A1 and is five digits as shown,
then enter this in B1:
=MID(A1,5,1)&MID(A1,4,1)&MID(A1,3,1)&MID(A1,2,1)&M ID(A1,1,1)
You could use RIGHT in the first expression and LEFT in the final
expression, but this makes it easier for you to see how to cope with 6
or 7 digit numbers etc.
The formula can be copied down for as many numbers as you have, and
leading zeros will be preserved as you will end up with a text value
that looks like a number.
Hope this helps.
Pete
JohnB wrote:
I have a list of data and i need to reverse the order of the numbers..for
example
46183
29830
50784
49774
22199
needs to be
38164
03892
48705
47794
99122
Please help.
Thank you in advance.
|