Formatting cells as hexadecimal

J

Joe

I want to format cells as hexadecimal. When I import a
text file with hex numbers in it Excel interprets 07E06
as scientific notation and changes the cell to 7.00E+06.
I want to convert this hex number to decimal but cannot
because Excel has erroneously converted it to scientific
notation. Any ideas?
 
D

Dave Peterson

If you rename your text file to .txt, then import the file (File|open?), you'll
see a text to columns wizard that will allow you to specify each field.

You can tell excel that that field is text--so it won't "help" by converting
your data.
 
G

Guest

Thanks Dave,

I import text files all the time and I have missed that
very simple step! Regards!
 

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
large numbers as text replaced with scientific notation 2
Number Formatting help 3
Excel converts 9-digit string to sci. not. when saved as csv 1
Scientific notation from a csv file 1
Format cells for hexadecimal numbers 2
How do I represent data in a cell as hexadecimal without converti. 1
text converted to scientific notations 3

Top