Importing a text file
 

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.

Importing a text file
 

This is only a display problem. The cell shows:

-4.07E-05

but the value in the formula bar will show:

-0.0000407051122205852
--
Gary''s Student - gsnu200842


"Helena Mouriño" wrote:

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.