| From(投稿者): | noone@nowhere.com |
|---|---|
| Newsgroups(投稿グループ): | fj.comp.applications.excel |
| Subject(見出し): | how to import hex and decimal? |
| Date(投稿日時): | Sat, 1 May 2004 02:31:59 GMT |
| Organization(所属): | Posted via Supernews, http://www.supernews.com |
| Message-ID(記事識別符号): | (G) <10962uvh6ah5o65@corp.supernews.com> |
How can I import a text file where some columns contain decimal real numbers and some columns contain hex numbers? like: 2.3 2E10 1E20 4.3 21FF F230 One problem was Excel read the hex "2E10" as exponential decimal 2.0E10 help please thanks Duane