View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Hexadecimal to Binary Conversion

install the analysis toolpak add in, then enter this

=HEX2BIN("F",8)


--


Gary


"sean_f" wrote in message
ups.com...
hi all,

does anyone know how to convert from hexadecimal
00017fff
or
3

to binary
00000000000000010111111111111111
or
011

Many Thanks
sean