Need Help

[Rich]

Would kindly appreciate any help given on this subject,

I am currently trying to compile a workbook that converts a number into
different number systems e.g. hex, bin, oct.
--------------------------------------------------------
No entered - Bin - Hex - Oct

8 00001000 etc etc
--------------------------------------------------------
What would be the best way to go about making this? - ideally i would
like to have a number of sheets each containing the calculations of
each number base.

A desperate plea goes out to anyone who can advise or kick start the
workbook,

Thank you for taking the time to read this.

Rich

 

[J.E. McGimpsey]

For entries from -512 to 511:

A1: <decimal entry>
B1: =DEC2BIN(A1)
C1: =DEC2HEX(A1)
D1: =DEC2OCT(A1)

Note: these functions are in the Analysis Toolpak Addin
(Tools/Addins, check the appropriate checkbox). You can specify the
number of digits - see XL Help.

For entries from -536,870,912 to 536,870,911

B1: =LongDec2Bin(A1)

where LongDec2Bin (and references to similar functions) can be found
at

http://www.mcgimpsey.com/excel/longdec2bin.html