| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop Hexadecimal being converted wrongly to scientific?
I often need to import strings of delimited hexadecimal numbers into Excel
however I am frustrated by EXCEL treating a hex number 1E4 into 10,000 (ie 1 times 10 to the power 4). How can I stop this ??? Thanks in advance Steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop Hexadecimal being converted wrongly to scientific?
Change your default column format of HEX data to text.
You can do it by Style in format menu. Change it form Genetal to Text. Was this helpful? "Steve Harvey" wrote: I often need to import strings of delimited hexadecimal numbers into Excel however I am frustrated by EXCEL treating a hex number 1E4 into 10,000 (ie 1 times 10 to the power 4). How can I stop this ??? Thanks in advance Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scientific Formatting takes over - how to stop... | Excel Discussion (Misc queries) | |||
| Stop scientific format | Excel Discussion (Misc queries) | |||
Linear Mode
