| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting from Decimal to Base-36 in Excel Formula
Hi! Hoping someone can help with this...
I found this very nice formula in another post that converts a Base-36 # to decimal: =IF(A1="","0",SUMPRODUCT(POWER(36,LEN(A1)-ROW(INDIRECT("1:"&LEN(A1)))),(CODE(UPPER(MID(A1,RO W(INDIRECT("1:"&LEN(A1))),1)))-48*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<58 )-55*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))64 )))) Can someone write me the opposite code in a similar Excel formula format? ie, converting a # as high as 999999999999999 (15 9's) to Base-36 ... I'm using web converters right now as an alternative and the Base-36 converted # is "9ugxnorjlr" If the code, like above, can accommodate other Base-X conversion (by changing the "36"), that would be even better, thanks! -Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting amount($) of my expenditure into the base currency i wa | Excel Discussion (Misc queries) | |||
| formulat to convert base 32 to decimal? | Excel Worksheet Functions | |||
| Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| formula for converting decimal to inch & fraction | Excel Discussion (Misc queries) | |||
Threaded Mode
