•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why does HEX2DEC() work with "0003861024" but not with "00003861024"?
I am trying to convert a column of hexadecimal numbers represented as text to decimal numbers. The first number I want to convert has five leading zeroes. The HEX2DEC() function gives me #NUM. If I remove two zeroes, leaving 3, the conversion works. If I remove one zero, leaving 4, the conversion does not work. Why not, and what's the best way to get around this?
In the meantime, I'm going to try to figure out a formula to convert "000003861024" to "3861024".
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#HEX2DEC
#hexadecimal
#decimal
#leading zeroes
##NUM
#function
#conversion
#formula
#text
#column
#zeroes
#convert