Converting from bin to hex, won't display nonnumeric chars 1

[NAB]

hellooo

i'm trying to convert from binary to hexidecimal, i've sorted out the formular =sum(bin2hex(number)) but if i try to use a binary number that gives a non-numeric output in hex, all i get is #value.

any help????

neil

 

[NAB]

sorry should have mentioned, i'm using excel

 

[Dreamboat]

Neil: I don't know what you're trying to get, 'cause I know nothing about hex-whatever.

I do know that you can't SUM text. You might be able to use CONCATENATE, dunno. Something like =concatenate(bin2hex(text))

Worth a shot, I guess.

Here's what concatenate does and another way to use it:

A1= Neil
B1= NAB

=A1&" "&B1
=CONCATENATE(A1," ",B1)

Either returns Neil NAB (including space between)
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[NAB]

dreamboat, you are a star mate!!!!

i didn't try the conc thing, but you got me thinking about why i was putting the =sum() in there, and well i don;t know why.

so i removed it and ay presto bin2hex(number) works on its own.

 

[Dreamboat]

Cool~
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com