Change RADIX within Excel cell

S

susheth

Is there a way (or plug-in) to change the radix of the displayed value
in Excel?

For example of I have a number represented in decimal within a cell,
say '10'. I would like it to be displayed in hex 'A' or binary '1010'.

This will be useful for many computer engineers.
 
G

Guest

Lookup BIN2HEX, HEX2BIN plus many more in help, they are part of the Analysis
ToolPak that comes with excel


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement 'atoi' when radix=16 and number string is negati 3
A non roundup decimal place cell format 6
Excel Stop Excel from displaying rounded values 4
What 'value' is a Dec2Bin output? 9
Equations and Text in same Cell 2
how do I change format for displaying data in cell? 3
Excel 2003 2
[newbie] Macro for "copy and paste" 1

Top