number changes from text to excel

  • Thread starter Thread starter Skip4t8
  • Start date Start date
S

Skip4t8

I have a .txt file containing a string of numbers e.g.
01098UC915 STORE 006383253581087039 8
when I open with Excel all the numbers change to having a zero on the end,
so 006383253581087039 becomes 006383253581087030 can you tell me what format
I should have in excel? I will need to save back as a text file when I have
modified.
Please help??
 
In Excel 2003, when opening a txt file the text importing wizard comes up.
Choosing the fixed length option it offers a dialog where you can change
column types. Your long string consists only of digits therefore Excel tries
to convert it to numbers but the resulted number exceeds Excel's 15 digit
limit. Set type of this column to text before finishing importing.

Regards,
Stefi

„Skip4t8†ezt írta:
 
You must log in or register to reply here.

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

Changing Text To Numbers ? 1
Red cell for negative numbers in Excel 1
Appending Text To Numbers ? 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Excell 2021 0
Default number format in Excel 1
Converting Numbers from Excel to TXT files 2
Columns formatted As Dates Are Exported as a Number to Text 1

Back
Top