Feb 21 2020 04:12 AM
Hi,
I am entering long numbers in an Excel sheet but it keeps changing me the last number. For example:
I enter 1040173012001159 and Excel changes to 1040173012001150.
I checked the cell format and it is as number.
Could you please give me an advise to solve this problema?
Best regards,
Feb 21 2020 04:17 AM
Excel keeps only first 15 digits of the long number and zeroes the rest. To keep all digits it shall be text, not number.
Feb 21 2020 04:18 AM
Feb 21 2020 04:21 AM
Hi, Thank you. I will try your suggestion.@Sergei Baklan