Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Hexadecimal Values Changed When Imported from .CSV File


View products that this article applies to.

This article was previously published under Q66033

↑ Back to the top


Summary

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

↑ Back to the top


More information

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 "Column Data Format" 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 "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.

↑ Back to the top


Keywords: KB66033, kbhowto

↑ Back to the top

Article Info
Article ID : 66033
Revision : 4
Created on : 9/19/2011
Published on : 9/19/2011
Exists online : False
Views : 570