General discussion

Locked

Excel 2K Question

By reginald.carolipio ·
A client is wondering if it is possible to force Excel to work in other numerical bases. I am trying to perform calculations on binary and/ or hexadecimal numbers. I know of the DEC2HEX, DEC2BIN and similar conversion functions, but I am trying tomanipulate the converted data. For example, I want to enter a decimal value, convert it to binary and bit test the binary value. Are any third party add-ins available that might enable this type of function?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 2K Question

by Bacon78 In reply to Excel 2K Question

You might try VBA. Click of a button or Submitting the Cell to a function.

All of your calculation can easily be done in VBA.

Hope this helps you.

Thanks,

Collapse -

Excel 2K Question

by reginald.carolipio In reply to Excel 2K Question

The question was auto-closed by TechRepublic

Collapse -

Excel 2K Question

by Cedric King In reply to Excel 2K Question

I do not know of any add-ins but writing the formula to convert decimal to binary is not that hard, just put in some thoughts and you will be able to figure out the formula.

Collapse -

Excel 2K Question

by reginald.carolipio In reply to Excel 2K Question

The question was auto-closed by TechRepublic

Collapse -

Excel 2K Question

by reginald.carolipio In reply to Excel 2K Question

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Software Forums