Hey Guys, Me again...
I figured out a little of what one needs to do in VB to get it into excel.. I've run into a couple of things hoping you can give me a little guidance.
1. When I first cut and pasted the formula that Damon gave for the bases in VB I got a message that there was an error in the formula. It highlighted the line that reads
Digit = X \ Base ^ i
What I did was delete one of the "" figuring that it was just a typo in the formula.. Is that correct.
2. After doing some quick programing I am wondering if there might be an error in the formula. I am not that familiar with counting in bases other than 10 so I might be wrong, please feel free to correct me if you know for sure, but for example it was my understanding that when counting in base 5 you would count as follows:
1,2,3,4,5,11,12,13,14,15,21,22,23,24,25,31...
The formula u gave me gives me the following for base 5 counting
1,2,3,4,5,10,11,12,13,14,15,20,21,22,23,24,25,30,31
Another example is counting in base 9
My understanding of base 9 counting is that it should count as follows:
1,2,3,4,5,6,7,8,9,11,12,13,14,15,16,17,18,19,21,22,23,24,25,26,27,28,29,31
The formula that u gave me gives the following for base 9 counting:
1,2,3,4,5,6,7,8,9,11,12,13,14,15,16,17,18,20,21,22,23,24,25,26,27,28,30
Is my understanding of counting in different bases wrong or is it possible that there is a slight "glitch" in the formula?
Thanks again for your assistance, it is greatly appreciated!
Best Regards,
Greg