Importing a text file

  • Thread starter Helena Mouriño
  • 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.
 
G

Gary''s Student

This is only a display problem. The cell shows:

-4.07E-05

but the value in the formula bar will show:

-0.0000407051122205852
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text File Importing 2
Access Subscript out of range when importing into access 2010 from excel 0
Importing text with text qualifier 2
Excel And Notepad 3
text file contains more data than will fit for a single worksheet 1
Importing Text Files Into Access 1
Importing a Text File Into 1 Column 3
Importing text files automaticly. 5

Top