If you want to manually enter hex values in cells ( or a column):
Format Cells... Text
or
Precede the entry with a single quote (apostrophe)
--
Gary''s Student - gsnu200734


"Gabriel Nehmer" wrote:

Even when choosing 'Column data format: text', the result is scientific
notation for 32-bit hex numbers that contain an 'E'. The file contains some
columns that are decimal numbers, some hex, some text.

I am using Microsoft Excel 2003 SP2.