Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hex numbers displayed in scientific notation when importing text f
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hex numbers displayed in scientific notation when importing text f
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hex numbers displayed in scientific notation when importing te
I am trying to process space-delimited text data that is 3000+ rows long
where some of it comes in as text, some as decimal number, some as hex number. I am trying to use Excel to process this data, and I would need something to pre-process it to add an apostrophe, but only to the column that has hex data before sending it to Excel. So, adding an Apostrophe won't work for me. My frustration is that Excel always handles an 'E' in a number like it's Scientific Notation, which it's not supposed to if you click import columns as 'Text' instead of 'General'. Why does it do this, and is there some way to turn this automation off? "Gary''s Student" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting as TEXT as opposed to scientific notation | Excel Discussion (Misc queries) | |||
Scientific Notation - I want excel to read it as a text not a numb | Excel Discussion (Misc queries) | |||
Scientific notation in text cells | Excel Discussion (Misc queries) | |||
Using scientific notation in TEXT() function | Excel Worksheet Functions | |||
Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) |