Any ideas around this one are extremely welcome!

I am currently using the HEX2DEC function to convert Hexadecimal addresses to decimal equivalents, the problems I have are as follows:

- Excel inconveniently uses auto conversion on all HEX number that have 'e' in them.
E.g. 3e06. Excel will convert this to 3000000 or 3e+6

Any ways round this??

The other problem is that currently the hex numbers are in the format 0x####, I am stripping the '0x' off the number as the HEX2DEC function will not recognise the number in this format

Please help!