Excel misrepresenting digits.

%3CLINGO-SUB%20id%3D%22lingo-sub-1676438%22%20slang%3D%22en-US%22%3EExcel%20misrepresenting%20digits.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676438%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Recently%20purchased%20Office%2019.%20One%20of%20my%20xcel%20files%20is%20misbehaving.%20When%20i%20type%20a%20correction%20to%20a%20number%20string%20in%20any%20field%20it%20will%20only%20show%20a%200%20for%20the%20corrected%20number%20no%20other%20digit%20no%20matter%20which%20number%20I%20type.%20The%20digit%20is%20in%20the%20last%20place%20of%20a%2016%20digit%20numerical%20string.%20If%20I%20unlock%20the%20field%20and%20change%20the%20field%20type%20from%20number%20to%20%22General%22%20or%20%22Text%22%2C%20then%20I%20get%20something%20even%20more%20erroneous%20than%20the%20numbers%20I'm%20trying%20to%20represent.%26nbsp%3B%20I%20am%20the%20file%20creator%20%2F%20owner%20and%20all%20the%20data%20contained%20therein%20is%20mym%20own%20and%20is%20password%20protected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BIs%20this%20a%20known%20bug%2C%20and%20if%20so%20is%20there%20a%20fix%3F%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1676438%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676511%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20misrepresenting%20digits.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676511%22%20slang%3D%22en-US%22%3EFifteen%20digits%20is%20the%20limit.%20The%20digits%20after%2015%20are%20changed%20to%20zero.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20should%20be%20able%20to%20format%20the%20cell%20as%20text%20and%20re-enter%20your%20number%2C%20but%20you%20won't%20be%20able%20to%20use%20it%20for%20mathematical%20calculations.%3C%2FLINGO-BODY%3E
Occasional Visitor

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 matter which number I type. The digit is in the last place of a 16 digit numerical string. If I unlock the field and change the field type from number to "General" or "Text", then I get something even more erroneous than the numbers I'm trying to represent.  I am the file creator / owner and all the data contained therein is mym own and is password protected.

 

 Is this a known bug, and if so is there a fix?  

2 Replies
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.

@jmmanuto ,,, for etter understanding please either share some sample data or upload the Sheet even,, in case of Formula, Excel has an option,, always return ZERO,,, check this with File,, Option,,, .