Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conversion of Dec numbers to Bin, Oct and Hex and visa versa
I'm attempting to produce an excel spreadsheet that can convert decimal
numbers (up to any value) to binary, octal and hexadecimal. Conversely I'm also trying to produce an excel spreadsheet that can convert Hex values to binary, octal and decimal. I need to create this spreadsheet without the use of the dec2hex, dec2bin etc excel functions. Basically the spreadsheet needs to be able to replicate the results of these excel functions without actually using them. The solution has to be contained within the spreadsheets. I can't use the VB module within Excel to derive the solution. Thanks for your help Regards....Kaleem My email address is |
#2
|
|||
|
|||
See response in worksheetfunctions
-- HTH Bob Phillips "xzl6pl" wrote in message ... I'm attempting to produce an excel spreadsheet that can convert decimal numbers (up to any value) to binary, octal and hexadecimal. Conversely I'm also trying to produce an excel spreadsheet that can convert Hex values to binary, octal and decimal. I need to create this spreadsheet without the use of the dec2hex, dec2bin etc excel functions. Basically the spreadsheet needs to be able to replicate the results of these excel functions without actually using them. The solution has to be contained within the spreadsheets. I can't use the VB module within Excel to derive the solution. Thanks for your help Regards....Kaleem My email address is |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|