|
|
#1
05-16-2017, 08:48 AM
|
|||
|
|||
long digit error
when i type this number 5665866763562961
i get this error 5.66587E+15 in the cell and when i click it then changes the digit to 5665866763562960 look forward to your help 
|
|
#2
05-16-2017, 10:14 AM
|
||||
|
||||
|
It's not an error it is scientific notation for representing large number. ... Excel has a precision limit of 15 digits so anything after the 15th digit becomes a zero.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Selecting a digit from a code | Warren99 | Excel | 2 | 05-29-2016 04:08 AM |
 Excel error in inputting long numbers
|
johnharbo | Excel | 12 | 03-09-2016 10:04 PM |
| Regex/wildcard search for dates with 2-digit and 4-digit years | Marrick13 | Word VBA | 2 | 01-29-2016 07:04 AM |
|
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9
|
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
| Renaming Word Formfields: string too long error | silverspr | Word VBA | 7 | 01-22-2013 06:20 PM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
