#1
|
|||
|
|||
Display Numbers in CSV file over 15 digits
Hi,
I download a data file from a system in CSV format, one of the column contains serial numbers which are more than 15 digits. it looks like this: 8.91E+18 I will need the 18 digits as reference number to do vlookup in other reports. However, no matter how I manipulate the data, the last a few digits only show as zero ever though I know they should not be, looks like this: 8912220000248760000 I know that Excel only can only take 15 digits of numbers in a cell, but is there a way to make it become text and to show all 18 digits properly? In another word, how can I find out whether the last a few digits were indeed missing in the downloaded CSV file? Thanks! |
#2
|
|||
|
|||
Open the file while in Excel (i.e. File:Open).
On the bottom right of the Open File dialog box. Select your file and click Open. Click Next twice to get to Data Format selection dialog. Select Text for Column Data Format. Click Finished. I tried it with just one number and it worked. Your results may vary. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to replace digits with letters | Bananabean | Word VBA | 6 | 09-14-2013 09:28 PM |
Separate the digits into 3 combinations | Jasa P | Word VBA | 1 | 08-19-2012 11:04 PM |
Problems merging in last 4 digits of an account higher than 16 digits | Glynda | Mail Merge | 1 | 04-08-2011 12:17 AM |
Display Random Numbers as Transition | greenbutton | PowerPoint | 0 | 03-09-2011 04:43 PM |
How to delete first 6 Digits and one Space from a CELL? | Learner7 | Excel | 3 | 08-10-2010 04:06 AM |