m**********0
发帖数: 6 | 1 it translates hex number (text) such as "11E02" automatically into "1.10E+03
" (ie, excel uses scientific field to treat the number). When force it to
be text, it becomes "1100". It is a nightmare for me to change it manually
if the file is big.
Any clever way to handle this? |
c****p
发帖数: 6474 | 2 不懂，，，11E02能转成1.10E+03的话显然不是hex啊。。。
你指的txt文件里面是ascii码？
03
manually
【在 m**********0 的大作中提到】
: it translates hex number (text) such as "11E02" automatically into "1.10E+03
: " (ie, excel uses scientific field to treat the number). When force it to
: be text, it becomes "1100". It is a nightmare for me to change it manually
: if the file is big.
: Any clever way to handle this?
|
k*********d
发帖数: 841 | 3 16进制放excel里面干什么的呢？有实际用途么？
03
manually
【在 m**********0 的大作中提到】
: it translates hex number (text) such as "11E02" automatically into "1.10E+03
: " (ie, excel uses scientific field to treat the number). When force it to
: be text, it becomes "1100". It is a nightmare for me to change it manually
: if the file is big.
: Any clever way to handle this?
|
a*m
发帖数: 6253 | 4 use data->import-> format |
