| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number convert to text in excel | Excel Discussion (Misc queries) | |||
| can we convert number to text in excel as if 1= One | Excel Discussion (Misc queries) | |||
| Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
Linear Mode
