Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
![]() Greetings all I now to I can convert between different base systems using the code Function baseconv(InputNum, BaseNum) Dim quotient, remainder As Single Dim answer As String quotient = InputNum ' Set quotient to number to convert. remainder = InputNum ' Set remainder to number to convert. answer = "" Do While quotient < 0 ' Loop while quotient is not zero. ' Store the remainder of the quotient divided by base number in a ' variable called remainder. remainder = quotient Mod BaseNum ' Reset quotient variable to the integer value of the quotient ' divided by base number. quotient = Int(quotient / BaseNum) ' Reset answer to contain remainder and the previous answer. answer = remainder & answer ' Convert answer variable to a number. Loop baseconv = Val(answer) End Function but how can I get letters to show up in bases like 25 or 40? Like in the Hex system. Thanks SAL2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I not show certain Letters in a range of cells in excel? | Excel Worksheet Functions | |||
How do I make letters not show up in a alpha-numeric string? | Excel Worksheet Functions | |||
Cannot save external data into file excel system show not respondi | Excel Discussion (Misc queries) | |||
how to show different photos, base on different value of a cell? | Excel Worksheet Functions | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) |