Solved

excel formatting

Posted on 2014-09-19
8
62 Views
Last Modified: 2014-09-19
WHen I try to open a tab file in excel ,

excel turns the following number 6006496679000165848 to scientific notation, and furthermore to 6006496679000160000.  

When I view the doc in notepad the number is indeed 6006496679000165848.  I have tried various delimited importing options with no luck.  Any ideas?
0
Comment
Question by:tike55
8 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40333353
During the import did you format columns with scientific notation?
0
 

Author Comment

by:tike55
ID: 40333356
No,  also the file is a .tab, but there is commas in the file.  I check comma as the delimiter
0
 

Author Comment

by:tike55
ID: 40333359
in the import wizard the view of the data is correct, the error happens when I click finish, and it opens in excel.
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40333361
Can you attach file or few lines so that i can try to recreate the issue?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 40333373
You can't have more than 15 digits as integer, the rest will turn to 0, no matter what it is.
To import from the file, set the field to Text in the import wizard.
0
 

Author Comment

by:tike55
ID: 40333391
Figured it out, I selected the column in the import wizard, and set it to text.
0
 

Author Comment

by:tike55
ID: 40333479
I've requested that this question be closed as follows:

Accepted answer: 0 points for tike55's comment #a40333391

for the following reason:

I figured it out with experts' help
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40333480
Points should be awarded to Ejgil Hedegaard for correctly identifying the issue and offering the solution.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now