Home

HEX2BIN How to convert hexadecimal numbers over 511 to binary??

%3CLINGO-SUB%20id%3D%22lingo-sub-904523%22%20slang%3D%22en-US%22%3EHEX2BIN%20How%20to%20convert%20hexadecimal%20numbers%20over%20511%20to%20binary%EF%BC%9F%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904523%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIf%20I%20want%20to%20convert%20sixteen%20binary%202222%20into%20binary%2010%200010%200010%200010%20in%20Excel%2C%20how%20to%20achieve%EF%BC%9F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20621px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F136575iE148EDC9115E825F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PFEt2rh8-Sywg-Ip-L%22%20title%3D%22PFEt2rh8-Sywg-Ip-L%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20Excel%20function%20HEX2BIN%2C%20why%20the%20valid%20value%20is%20limited%20to%20-512%20to%20511%20(including%20the%20valid%20values%20between%20the%20two%20ends)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-904523%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-904562%22%20slang%3D%22en-US%22%3ERe%3A%20HEX2BIN%20How%20to%20convert%20hexadecimal%20numbers%20over%20511%20to%20binary%EF%BC%9F%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904562%22%20slang%3D%22en-US%22%3EFound%20a%20solution%3CBR%20%2F%3E%3D%20BASE(HEX2DEC(A1)%2C%202)%3CBR%20%2F%3ENeed%20Office%202010%20or%20above%3C%2FLINGO-BODY%3E
z888888
New Contributor

If I want to convert sixteen binary 2222 into binary 10 0010 0010 0010 in Excel, how to achieve?

PFEt2rh8-Sywg-Ip-L
The Excel function HEX2BIN, why the valid value is limited to -512 to 511 (including the valid values ​between the two ends)

1 Reply
Found a solution
= BASE(HEX2DEC(A1), 2)
Need Office 2010 or above
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies