Forum Discussion
jmmanuto
Sep 17, 2020Copper Contributor
Excel misrepresenting digits.
I have Recently purchased Office 19. One of my xcel files is misbehaving. When i type a correction to a number string in any field it will only show a 0 for the corrected number no other digit no mat...
JMB17
Sep 17, 2020Bronze Contributor
Fifteen digits is the limit. The digits after 15 are changed to zero.
You should be able to format the cell as text and re-enter your number, but you won't be able to use it for mathematical calculations.
You should be able to format the cell as text and re-enter your number, but you won't be able to use it for mathematical calculations.