Stupid hex2dec function in excel (can confuse blank space in front)

If you point your number to a cell reference, it supposed to convert hex to dec for you. But if there's a space in front of the hex number, then you'll get error. This is ridiculous. I need to get rid of the space before it'll convert the hex number correctly.