ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   =Dec2bin can you increase the number bits please (https://www.excelbanter.com/excel-discussion-misc-queries/102001-%3Ddec2bin-can-you-increase-number-bits-please.html)

WAT

=Dec2bin can you increase the number bits please
 
Currently the limit on bits is 10 could can you have and intern spend a
couple days increase the number of bits. Many VB examples so it should not
take more than a couple days. I have other tools but I love excel many
thanks. Plus I am sure that I could use that extra rows for creating memory
maps. Please, pretty please it would realy save some time. I am not looking
for matlab or building C program its nice to have excel

Can you fix them all
=DEC2HEX(-1, 10)
=DEC2OCT(-1,10)
=Hex2bin(Fx,10)
=Hex2dec(fx,10)
=BIN2DEC(1000000000)
Floating point would be cool single precision and double precision ascii
=DEC2FLOAT key ones DEC2FLOAT
=DEC2DFLOAT
=HEX2FLOAT
=HEX2DFLOAT
=BIN2FLOAT
=BIN2DFLOAT
=OCT2FLOAT
=OCT2DFLOAT
=FLOAT2BIN(1x,x) rounded
=DFLOAT2BIN(x,x) rounded
=FLOAT2HEX(1, x) rounded
=€¦..


Maybe you could even add truth table logic like processor xor nor nand rol €¦.

--
Think Deep

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com