#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! |
|
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 |