Converting Bin to Hex

Robert Lowe · Aug 28, 2004

I type in this formula, and everything's great. But when I edit it,
something goes wrong and it no longer reads as a formula. Has anyone else
experienced this?

=BIN2HEX( CONCATENATE( K12,K13,K14,K15,K16,K17),2)

Thank you.

Frank Kabel · Aug 28, 2004

Hi
maybe the cell is formated as 'Text'. Change this format to 'General'

Robert Lowe · Aug 29, 2004

Many thanks Frank.

Regards
Robert

Frank Kabel said:
Hi
maybe the cell is formated as 'Text'. Change this format to 'General'

Converting Bin to Hex

Robert Lowe

Frank Kabel

Robert Lowe