Microsoft KB Archive/66033

= Hexadecimal Values Changed When Imported from .CSV File =

Article ID: 66033

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 98 for Macintosh
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q66033





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



Hexadecimal Numbers
Hexadecimal numbers may not be correctly interpreted when you import them into Excel. Because 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.

You can maintain a hexadecimal number's original format by selecting the text option found under &quot;Column Data Format&quot; in Step 3 of 3 of the Text Import Wizard. The Wizard will automatically start when opening a text file.

Alphanumeric
Alphanumeric entries, in which &quot;e&quot; or &quot;E&quot; is the only alpha character in the string and &quot;e&quot; or &quot;E&quot; 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 =&quot;123E4&quot; in the text file.

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

Additional query words: xl98 xl97 xl2000 xl2001 xl2002 XL

Keywords: kbhowto KB66033

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.