XL: Hexadecimal Values Changed When Imported from .CSV File

ID: Q66033

The information in this article applies to:

SUMMARY

This article describes how hexadecimal numbers, alphanumeric entries, and numerical entries are interpreted when you import them into Microsoft Excel.


MORE INFORMATION

Hexadecimal Numbers

Hexadecimal numbers may not be correctly interpreted when you import them to Microsoft Excel. Because Microsoft Excel reads certain hexadecimal numbers, such as 06E2, as scientific notation, the hexadecimal number 06E2 will be imported as 6.00E+02 or as 600 in the decimal format.

If you use a version 5.0 or later of Microsoft Excel, you can maintain a hexadecimal number's original format by selecting the text option found under "Column Data Format" in Step 3 of 3 of the Text Import Wizard. The Wizard will automatically start when opening a text file in Microsoft Excel 5.0 or later.

If you are using Microsoft Excel 4.0 or earlier, you could open the delimited text file in a text editor such as Notepad or Teach Text, and enter the affected hexadecimal values as a text string before importing to Excel. For example, change 06E2 to: 


   ="06E2"


NOTE: If you enter ="06E2" in a Microsoft Excel worksheet and save the file as a text delimited file, Microsoft Excel converts ="06E2" into 06E2.

Alphanumeric

Alphanumeric entries, in which "e" or "E" is the only alpha character in the string and "e" or "E" is not the first or last character in the string, are interpreted as exponential numbers. For example, 123E4 will be interpreted as 123*(10)^4

To have this number interpreted as text, it also must be entered as ="123E4" in the text file.

Numeric

A numeric entry in the file, such as "1234," is imported as a number, not as text, and is aligned to the right.

For more information on importing files into Microsoft Excel, see the "Opening and Saving Text Files" the Application Note (WE0801 or ME0802). For information about this Application Note, query on the following words in the Microsoft Knowledge Base: 


   CSV and Opening and Text and Files and Saving

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00 4.0 4.00 4.0a 4.00a 5.0 5.00a 5.00c 7.00a 97 98 XL98 XL97 XL7 XL5 XL4 


Keywords          : xlformat 
Version           : WINDOWS:2.0,3.0,4.0,5.0,7.0,97; MACINTOSH:2.0,3.0,4.0,5.0,98; os/2:2.2,3.0
Platform          : MACINTOSH OS/2 WINDOWS 
Issue type        : kbinfo

Last Reviewed: March 22, 1999