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