number changes from text to excel
 

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??

number changes from text to excel
 

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:

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??