View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
sean_f sean_f is offline
external usenet poster
 
Posts: 16
Default Hexadecimal to Binary Conversion Without Using Analysis Tool Pak

Unfortunately I cannot rely on users to have the tool pak installed.

Thanks

sean



Gary Keramidas wrote:
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