number formats

%3CLINGO-SUB%20id%3D%22lingo-sub-799227%22%20slang%3D%22en-US%22%3Enumber%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799227%22%20slang%3D%22en-US%22%3E%3CP%3Eevery%20time%20I%20enter%20a%20number%20into%20a%20cell%2C%20it%20takes%20the%20last%20digit%20and%20turns%20it%20into%20a%20zero.%20I've%20tried%20all%20the%20formats.%26nbsp%3B%20I%20just%20need%20to%20enter%20a%20string%20of%20numbers%20without%20having%20the%20last%20digit%20be%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-799227%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799308%22%20slang%3D%22en-US%22%3ERe%3A%20number%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390571%22%20target%3D%22_blank%22%3E%40rjr70%3C%2FA%3E%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EThe%20maximum%20number%20of%20digits%20allowed%20in%20a%20single%20cell%20is%2015%20digits%3C%2FP%3E%3CP%3ESince%20I%20do%20not%20see%20a%20sample%20file%20with%20your%20question%2C%20may%20be%20the%20situation%20is%20you%20went%20beyond%20the%20allowed%20number%20of%20digits.%3C%2FP%3E%3CP%3EOtherwise%2C%3C%2FP%3E%3CP%3EA%20Custom%20number%20format%20may%20be%20created%20to%20fix%20the%20issue%20or%20maybe%20in%20some%20cases%20(Like%20Credit%20Card%20Numbers)%20we%20may%20format%20the%20cell%20as%20Text%2C%20so%20long%20as%20you%20are%20not%20going%20to%20use%20it%20in%20performing%20calculations%3C%2FP%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

every time I enter a number into a cell, it takes the last digit and turns it into a zero. I've tried all the formats.  I just need to enter a string of numbers without having the last digit be 0.

 

thank you.

1 Reply
Highlighted

@rjr70

Hi

The maximum number of digits allowed in a single cell is 15 digits

Since I do not see a sample file with your question, may be the situation is you went beyond the allowed number of digits.

Otherwise,

A Custom number format may be created to fix the issue or maybe in some cases (Like Credit Card Numbers) we may format the cell as Text, so long as you are not going to use it in performing calculations

Good Luck

Nabil Mourad