Thread: How do I stop Hexadecimal being converted wrongly to scientific?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Harvey Steve Harvey is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote