How to convert 14 bit Hex to Decimal

Question

I need to be able to convert 047C1BEA3A2480 into Decimal. This should convert to 1262359242482816. I have a large amount of hex numbers that need converting so would need a formula or VB script.

I have tried some things including a VB Module, however with this I need to prefix the number with 0X but then gives me a decimal number that is out by 4.

Any ideas would be great.

score 3 · Answer 1 · answered Jan 08 '14 at 13:04

3

Use the inbuilt CDec function

Debug.Print CDec("&H" & "047C1BEA3A2480")

This will give you 1262359242482816

Screenshot

enter image description here

answered Jan 08 '14 at 13:04

Siddharth Rout

147,039
17
206
250

Hi thanks for this. How could I do this on a mass scale? – Leigh Jan 09 '14 at 12:39
You can either use a for loop if you are doing it VBA or create a UDF for this – Siddharth Rout Jan 09 '14 at 12:40

score 1 · Answer 2 · answered Jan 08 '14 at 13:38

Split into 2 7-digits and use the HEX2DEC function. Unfortunately, Excel cannot handle that big a number, so it is rounding when you put it back in Excel. For exmaple, try to paste the decimal version into Excel. But if you want the formula anyway.

=HEX2DEC(LEFT(A4,7))*16^7+HEX2DEC(RIGHT(A4,7))

Otherwise, use Siddarth's solution and put it in Excel as Text.

How to convert 14 bit Hex to Decimal

2 Answers2