| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing last digit with Zero
I have a CSV file that has 16 digit numbers in it, when I open the file Excel
replaces the last digit with a zero. Saving it as an .xls file and changing the format to allow for a 16 digit number still gives the same results. If I open the file in notepad I can see the proper numbers in there. if you type in 1234567891234567 it will display it as 1.23457E+15, then when you change the format it replaces the 7 with a zero. Thanks, Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Check Digit | Charts and Charting in Excel | |||
| Excell Check Digit Formula | Excel Worksheet Functions | |||
| only 5 digit zip codes | Excel Discussion (Misc queries) | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
Threaded Mode
