=BIN2HEX(0) results in #NUM?

S

sunaba

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Why does BIN2HEX not work to convert 0 from binary to hex unless you explicitly state the number of places?

From what I can tell, this is new to this version, and unique to only the value 0.
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Why does BIN2HEX not work to convert 0 from binary to hex unless you
explicitly state the number of places?

From what I can tell, this is new to this version, and unique to only the
value 0.
Click to expand...
I'm curious to see Pat McMillian's answer to this one.
 
P

Pat McMillan

So, to follow up on this: we have verified this issue with our Hex
conversion functions and are investigating them now. Thanks for reporting
this.

Pat
 

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

error with exel 1
Excel has the NUM lock key on - my charts are messed up 1
Formulas in Chart Titles Axis Titles 4
cannot enter a long series of numbers without excel changing them. 3
saving semicolon-delimited files 2
Ledger Sheets 2
Number of copies when printing is 256, how can I set it back to 1? 2
excel - exporting bar graph 3

Top