|Posted: July 3, 2010, 7:30 pm - IP Logged|
This should work provided it's used for 8 digit numbers only.
Play around with it and you can get it for other digit sizes.
If the data is in A1, first paste this into B1.
After that, copy contents of B1 and paste into the other cells.
Excel will handle the column and row changes automagically.
Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.
Use at your own risk.
Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish