Formatting cells as hexadecimal

  • Thread starter Thread starter Joe
  • Start date Start date
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?
 
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.
 
Thanks Dave,

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