Solved

excel formatting

Posted on 2014-09-19
8
61 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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

708 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

19 Experts available now in Live!

Get 1:1 Help Now