LinkBack URL
About LinkBacks
Does anyone know how to display a 4digit HEX value as as Binary in Excel?
Excel only seems to have an accuracy of 10 Binary digits.
4digit HEX as Binary in Excel
Does anyone know how to display a 4digit HEX value as as Binary in Excel?
Excel only seems to have an accuracy of 10 Binary digits.
Last edited by dcloney; 03-15-2011 at 09:53 AM.
Welcome to the forum.
How about a UDF?
Copy the code to a code module and the apply as, for example,
Please Login or Register to view this content.
=HexToBin("ABCD")
Adding a Macro to a Code Module
1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Press Alt+Q to close the VBE and return to Excel
Entia non sunt multiplicanda sine necessitate
No luck im afraid.
Cheers for the help
Last edited by shg; 03-15-2011 at 03:50 PM. Reason: deleted spurious quote
Fixed it.
Accidentally missed part of the code when i was using VBE
Originally Posted by dcloney
l;lhklhkjghghjklghyjkl
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks