Import hexadecimal data into excel keeping hexadecimal format

W

Whale

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.
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hexadecimal data 2
Formatting cells as hexadecimal 2
Hexadecimal Numbers 5
Address Format changed after Migration 0
format numbers in hexadecimal 1
How do I represent data in a cell as hexadecimal without converti. 1
Excel issue saving files to hexadecimal filenames on terminal server... 1
++++ SUPPORT FOR HEXADECIMAL DATA IN EXCEL +++++ 5

Top