 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / March 2007Import *.csv file into Excel with 16-digit number converted to tex
I have *.csv file with 16-digit number(which is actually text ID), when I am trying to open this file with Excel- it shows the 'scientific' notation for this column, converting the column to text causes the rounding of the last digit to 0 and then I am not able to use it as an ID. In the Text Import Wizard, Step 3 of 3, you can force the import format of individual columns. There you must specify that the ID column is text. Otherwise, since Excel will interpret it as numeric, because it can. Excel (like almost all software) uses IEEE double precision strage for numers. Double precision is not capable of representing all 16 digit integers, so MS chose to never display more than 15 digits (documented in Help) for a number. Jerry > I have *.csv file with 16-digit number(which is actually text ID), when I am > trying to open this file with Excel- it shows the 'scientific' notation for > this column, converting the column to text causes the rounding of the last > digit to 0 and then I am not able to use it as an ID. Thank you very much, Jerry, your advice workes great with my data, you helped to solv long-standing problem :) Irina > In the Text Import Wizard, Step 3 of 3, you can force the import format of > individual columns. There you must specify that the ID column is text. [quoted text clipped - 11 lines] > > this column, converting the column to text causes the rounding of the last > > digit to 0 and then I am not able to use it as an ID. You're welcome. Glad it helped. Jerry > Thank you very much, Jerry, your advice workes great with my data, you helped > to solv long-standing problem :) > Irina Let you try add = "" & "<16-digit>" in your csv file For example: = "" & "0123456789123456789" I am not sure that this will help you. IrinaR เขียน: > I have *.csv file with 16-digit number(which is actually text ID), when I am > trying to open this file with Excel- it shows the 'scientific' notation for > this column, converting the column to text causes the rounding of the last > digit to 0 and then I am not able to use it as an ID.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.