Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Delimited Issue

Status
Not open for further replies.
RGarcia87

RGarcia87

Technical User
Jun 24, 2002
506
US
I have a raw file I'm importing into Excel Delimited, and semi-colon as the seperator.

One column contains a 16 digit account number. When I'm done importing, it changes the last digit to zero. The last digit can be a 7 or a 3, but still changes it to a 0 for some reason I cannot figure out.
 
Sort by date Sort by votes
limit of 15 numbers in the cell.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
If you do not need it as an actual number, when you import it it, define it as text.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Solved
Excel Unique-Filter issue
Replies
3
Views
275
SkipVought
S
Cpreston
  • Locked
  • Question
Pivot Table Issue
Replies
6
Views
339
Andrzejek
Andrzejek
Snirt
  • Locked
  • Question
MS-Office 2013 Excel Issue
Replies
1
Views
294
SkipVought
S
Cpreston
  • Locked
  • Question
vlookup issue 1
Replies
4
Views
251
combo
combo
R
  • Locked
  • Question
Issues with Outlook default account and performance
Replies
0
Views
477
radleymartinez
R

Part and Inventory Search

Sponsor

Back
Top