M
Marvin Buzz
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.
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.