Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hexadecimal data
I receive a .CSV file that contains hexadecimal data. Ordinarily, this
represents no problem, but occasionally, the raw data might look like this: 7E00 7E08 7DEC Excel displays these values as: 7.00E+00 7.00E+10 07-Dec clearly not the values I want displayed. The data comes from a source that I cannot control so there is no way to request the data in a different format. Is there a way to prevent EXCEL from making these changes? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hexadecimal data
Because the file is .csv, Excel is trying to "help" you. To avoid this
"help", first open Excel and then: Data Import External Data Import Data and then tell the Wizard which ..csv file to open. This forces the Import Wizard to ask you about the fields. Tell the Wizard that the field is text. Alternatively, rename the file to something other than .csv This will also force the Import Wizard to appear. -- Gary''s Student - gsnu200802 "Marvin Buzz" wrote: I receive a .CSV file that contains hexadecimal data. Ordinarily, this represents no problem, but occasionally, the raw data might look like this: 7E00 7E08 7DEC Excel displays these values as: 7.00E+00 7.00E+10 07-Dec clearly not the values I want displayed. The data comes from a source that I cannot control so there is no way to request the data in a different format. Is there a way to prevent EXCEL from making these changes? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hexadecimal data
Thank you. The Import worked fine.
"Gary''s Student" wrote: Because the file is .csv, Excel is trying to "help" you. To avoid this "help", first open Excel and then: Data Import External Data Import Data and then tell the Wizard which .csv file to open. This forces the Import Wizard to ask you about the fields. Tell the Wizard that the field is text. Alternatively, rename the file to something other than .csv This will also force the Import Wizard to appear. -- Gary''s Student - gsnu200802 "Marvin Buzz" wrote: I receive a .CSV file that contains hexadecimal data. Ordinarily, this represents no problem, but occasionally, the raw data might look like this: 7E00 7E08 7DEC Excel displays these values as: 7.00E+00 7.00E+10 07-Dec clearly not the values I want displayed. The data comes from a source that I cannot control so there is no way to request the data in a different format. Is there a way to prevent EXCEL from making these changes? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leading Zero in Hexadecimal? | Excel Discussion (Misc queries) | |||
Decimal to Hexadecimal | Excel Discussion (Misc queries) | |||
How do you sort a column with Hexadecimal data | Excel Discussion (Misc queries) | |||
Hexadecimal to binary | Excel Discussion (Misc queries) | |||
How do I represent data in a cell as hexadecimal without converti. | Excel Discussion (Misc queries) |