Import hexadecimal data into excel keeping hexadecimal format
 

I have copied a file which contains some hexadecimal formatted addresses.
However, I haven't been able to keep the same hexadecimal format in excel.
I don't want to convert the data to "text","general number", "scientific",
etc as the value will change and is thus useless to me. Examples are
"002100" changes to "2100", and "001E10" changes to "1E+10". Use converting
to hexadecimal functions do not seem sensible.
How can I keep the format exactly as the original data before importation?
Any ideas. I'm sure there is a simple solution.

Import hexadecimal data into excel keeping hexadecimal format
 

If you don't want it to change, you need to import it as text. If you then
want to do arithmetic with the hex values, you need to convert to a number,
with HEX2DEC.
--
David Biddulph


"Whale" wrote in message
...
I have copied a file which contains some hexadecimal formatted addresses.
However, I haven't been able to keep the same hexadecimal format in excel.
I don't want to convert the data to "text","general number", "scientific",
etc as the value will change and is thus useless to me. Examples are
"002100" changes to "2100", and "001E10" changes to "1E+10". Use
converting
to hexadecimal functions do not seem sensible.
How can I keep the format exactly as the original data before importation?
Any ideas. I'm sure there is a simple solution.