By SCWhen we write more than 15 digits in excelit converts digit after 15th number to zeros as shown below.
| 1.23457E+15 |
To write numbers greater than 15 digit first add ” ‘ ” in cell and type number and then convert it into “text” and remove ‘ from prefix and ignore error.As shown below in C column more than 15 digits are written.
after converting into text we can remove apostrophe(‘) and then ignore error.
