Importing a text file

  • Thread starter Thread starter Helena Mouriño
  • Start date Start date
H

Helena Mouriño

Dear all,

I need to import a text file into excel. Using the Notepad, I see that there
is a value of -4.07051122205852e-05 in the file. Using the text import wizard
I converted the file into the excel. I found out that the excel changes this
value to -4.07E+09!!!! I don't understand why this is happening only to this
single value. Can you give me some clues?

Thanks in advanced for helping me!

Best regards, Helena Mouriño.
 
This is only a display problem. The cell shows:

-4.07E-05

but the value in the formula bar will show:

-0.0000407051122205852
 
Back
Top