SOLVED

Problem with Excel: allows me only 3 digits max in the cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2325609%22%20slang%3D%22en-US%22%3EProblem%20with%20Excel%3A%20allows%20me%20only%203%20digits%20max%20in%20the%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325609%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20facing%20a%20problem%20with%20Excel%20and%20it's%20driving%20me%20crazy..%20Since%20yesterday%20Excel%20doesn't%20allow%20me%20to%20have%20more%20than%203%20digits%20in%20each%20cell.%20I've%20checked%20the%20data%20validations%20and%20there%20is%20no%20rules%20so%20why%20does%20the%20program%20automatically%20convert%20my%20numbers%20down%20to%203%20digits%2C%20it's%20really%20annoying%20as%20I%20cannot%20see%20any%20cause%20for%20it.%3C%2FP%3E%3CP%3EI%20put%203%20screenshots%20to%20show%2C%20the%20first%20one%20has%20the%20original%20value%20(it%20was%20saved%20before%20Excel%20started%20to%20go%20sideways)%20of%203%2C500.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20second%20screenshot%20shows%20the%20value%20I'm%20trying%20to%20put%20which%20is%2040%2C000.%3C%2FP%3E%3CP%3EFinally%20on%20the%20last%20screenshot%20we%20can%20see%20that%20Excel%20decided%20that%20the%20value%20will%20be%20400...%20Please%20I%20need%20some%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-05-05%20at%202.09.46%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278377i4DC72ECE603C40FA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-05-05%20at%202.09.46%20PM.png%22%20alt%3D%22Screen%20Shot%202021-05-05%20at%202.09.46%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-05-05%20at%202.10.00%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278378iB90284E647235C4B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-05-05%20at%202.10.00%20PM.png%22%20alt%3D%22Screen%20Shot%202021-05-05%20at%202.10.00%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-05-05%20at%202.10.08%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278379i86C9B16AF643A2DD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-05-05%20at%202.10.08%20PM.png%22%20alt%3D%22Screen%20Shot%202021-05-05%20at%202.10.08%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2325609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2329930%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Excel%3A%20allows%20me%20only%203%20digits%20max%20in%20the%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2329930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20thank%20you%20so%20much%20for%20your%20help%2C%20problem%20is%20solved.%20I'm%20still%20curious%20to%20know%20why%20Excel%20decided%20all%20of%20a%20sudden%20to%20implement%20this%20rule..%20anyway%20glad%20it's%20fixed.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2326011%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Excel%3A%20allows%20me%20only%203%20digits%20max%20in%20the%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326011%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045588%22%20target%3D%22_blank%22%3E%40JohnnyDubai%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20on%20the%20Excel%20menu%20and%20select%20Preferences.%3C%2FP%3E%0A%3CP%3EClick%20Edit%2C%20then%20clear%20the%20check%20box%20%22Display%20this%20number%20of%20decimal%20places%22.%3C%2FP%3E%0A%3CP%3EDoes%20that%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

 

I'm facing a problem with Excel and it's driving me crazy.. Since yesterday Excel doesn't allow me to have more than 3 digits in each cell. I've checked the data validations and there is no rules so why does the program automatically convert my numbers down to 3 digits, it's really annoying as I cannot see any cause for it.

I put 3 screenshots to show, the first one has the original value (it was saved before Excel started to go sideways) of 3,500. 

The second screenshot shows the value I'm trying to put which is 40,000.

Finally on the last screenshot we can see that Excel decided that the value will be 400... Please I need some help!

 

Screen Shot 2021-05-05 at 2.09.46 PM.png

Screen Shot 2021-05-05 at 2.10.00 PM.png

Screen Shot 2021-05-05 at 2.10.08 PM.png

 

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@JohnnyDubai 

Click on the Excel menu and select Preferences.

Click Edit, then clear the check box "Display this number of decimal places".

Does that help?

@Hans Vogelaar 

Yes thank you so much for your help, problem is solved. I'm still curious to know why Excel decided all of a sudden to implement this rule.. anyway glad it's fixed.