?
Solved

import from tsv causing formatting issues

Posted on 2014-02-18
2
Medium Priority
?
172 Views
Last Modified: 2014-02-18
I am trying to import some data into excel from a tab seperated file. However, column G, which is a numercial sequence of 11 characters, normally beginning with 1, is importing as a bizarre format, i.e. "1.0003E+11". how can I amend the import stage so it maintains the correct format of the data? weirdly it only seems to affect some rows of data and not all.
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 8

Accepted Solution

by:
Naresh Patel earned 2000 total points
ID: 39866823
Hi pma111,

The maximum numbers you can put in one cell is 15 digit. so I guess you just have to change format of that column General To Number format.


Thanks
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39866828
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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