Thread: Excel automatically changing my column with "E" to exponential Num
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Plukey2 Plukey2 is offline
external usenet poster
  
Posts: 7
Default Excel automatically changing my column with "E" to exponential Num
We transfer data from a database to Excel for multiple reasons. The ID to
our records are 6 characters such as "123A12" "456B12". When we have an ID
such as "419E07" Excel automatically changes that to 4.19E+09. A group of
us has tried EVERYTHING we know to stop this from happening. When we open
Excel, we DO NOT want Excel to convert. Any ideas?
Reply With QuoteReply With Quote