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

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