Home

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
rjr70
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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies