I read a file of hex numbers into Excel. I then paste the function HEX2DEC
into
coulumn C. I select column A (where the file of hex numbers were entered) as
the
numbers to convert. The vast majority of the numbers are converted correctly,
however hex numbers such as 34e3 are converted as if they are in sciencetic
notation. example
1.00E+08 4294967296 WRONG should be 1e08 = 7688
1.00E+08 4294967296
00000010d8 4312 right
1.10E+07 285212672
2.00E+18 #NUM!
2.00E+10 #NUM!
2.00E+46 #NUM!
2.00E+46 #NUM!

and I have seen 5dec be converted as a date!

What am I doing wrong? How do I tell Excel that column A is strictly hex
numbers?