Base-36 Numbers? or Reverse of ToNumber()?

1

Does anyone have a method for creating Base-36 numbers? Or am I missing the formula somewhere?

I would essentially like to perform the opposite of ToNumber(). For example, ToNumber("P", 36) = 25. I would like to do the opposite where I input “25” and the result is “P.”

Thanks!

2

Well, you can use Character() for ASCII code -> character conversion. Character(65) outputs ‘A’, and it’s up from there. Pair with some conditional logic and math, and you’ll have a conversion function.

1 Like
3

Good idea! I’ll go with that. Thanks!