Hexadecimal to Binary Conversion

install the analysis toolpak add in, then enter this

=HEX2BIN("F",8)


--


Gary


"sean_f" <[email protected]> wrote in message
news:[email protected]...
> hi all,
>
> does anyone know how to convert from hexadecimal
> 00017fff
> or
> 3
>
> to binary
> 00000000000000010111111111111111
> or
> 011
>
> Many Thanks
> sean
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > hi all,
> >
> > does anyone know how to convert from hexadecimal
> > 00017fff
> > or
> > 3
> >
> > to binary
> > 00000000000000010111111111111111
> > or
> > 011
> >
> > Many Thanks
> > sean
> >