Thread: importing numeric data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default importing numeric data
Can you open the other program output in Notepad and tell us what you see?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"slapshot26" wrote in message
...
Every time I open a file with numeric data (in scientific notation) from
another program, the decimal place gets moved.
Ex: 1.04465E-2 (or 0.014465) becomes 1.04465E2 (or 104.465)
Is there any way to stop the changing of the sign?

Reply With QuoteReply With Quote