Re: $$Excel-Macros$$ How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

2016-02-15 Thread XL Macros
Paul, If i understood your requirement correctly then below formula works out for you [image: Inline image 1] I have attached sample file as well. Regards, Karthik On Thu, Feb 11, 2016 at 5:57 AM, Paul Bevins wrote: > Hi, I've got an odd problem. > > I have a

$$Excel-Macros$$ How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?

2016-02-10 Thread Paul Bevins
Hi, I've got an odd problem. I have a database of some 15000 numbers. 10,000 of them (roughly), go from 1 to 10,000. Another 5,000 go from 1,000,000 to 2,000,000. However, the numbers SHOULD AB1 to AB1. I need to be able to type the root number in and have Excel decide what it needs: