Leading Zeros for Base 10 to Base 36 Converter

**norman.johnson** · 07-06-2011, 05:58 PM

Hi all,

Tried to respond to your posts, but it keeps saying that my message is too short even though it is longer than the 10 characters required. Sorry.

I got this vb conversion program from Tony who posted on Excel Forum. The program converts base 10 to base 36. The program works great. I just need it to add leading zeros in front of the base 36 number it generates. Does any one know how to do this? See the program below, thanks

:

Please Login or Register  to view this content.

**stnkynts** · 07-06-2011, 06:01 PM

So much wrong with your post. Expect to get lit up by mods

**Mordred** · 07-06-2011, 06:03 PM

Hi norman.johnson and welcome to the forum. Please take a moment to read the forum rules located here and amend your title as per Rule #1. Also, you must wrap your code in code tags as per Rule #3. Once you do that, someone will be able to help you.

**stnkynts** · 07-06-2011, 06:56 PM

I am not all that versed in the difference between Base 10 and Base 36. Just did a wikipedia search. I am not sure if the Base 36 by definition should have zeroes in front of it that is getting cut off or if you just want to add a zero in front of it. If the latter it might be a formatting issue or you could try the untested change below.

Change

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

**shg** · 07-06-2011, 07:22 PM

Here's similar UDF with the ability to specify the length:

Please Login or Register  to view this content.

E.g., =DblToBase(1E15, 36, 12) returns 009UGXNORJLS

**norman.johnson** · 07-07-2011, 08:01 AM

Originally Posted by stnkynts

I am not all that versed in the difference between Base 10 and Base 36. Just did a wikipedia search. I am not sure if the Base 36 by definition should have zeroes in front of it that is getting cut off or if you just want to add a zero in front of it. If the latter it might be a formatting issue or you could try the untested change below.

Change

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Thanks Stnkyts, that worked.

**royUK** · 07-07-2011, 08:09 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved. Do not report the post, you can also give the person Rep points

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save