| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Import *.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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| Numbers Converted to Text - Last Digit Replaced by Zero | Excel Worksheet Functions | |||
| Accidentally converted date mm/dd/yy to a 5 digit number | Excel Worksheet Functions | |||
| On an import to excel a two digit date still is not right after c. | Excel Discussion (Misc queries) | |||
Threaded Mode
