I think it depends on what country your Excel thinks it in but the semicolon in your formula needs to be a comma. Also you have cell A52 in your formula, not A1. Here is a little fix...: =HEX2DEC(MID(SUBSTITUTE(A1,":",""),7,2)) & "." & HEX2DEC(MID(SUBSTITUTE(A1,":",""),5,2)) & "." & HEX2DEC(MID(SUBSTITUTE(A1,":",""),3,2)) & "." & HEX2DEC(MID(SUBSTITUTE(A1,":",""),1,2)) Also, I'm not sure how this Excel formula is going to handle a single digit Octet that isn't padded with a leading zero.
... View more