Forum Discussion
Solved
Problem with Excel: allows me only 3 digits max in the cells
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 ther...
Click on the Excel menu and select Preferences.
Click Edit, then clear the check box "Display this number of decimal places".
Does that help?
Click on the Excel menu and select Preferences.
Click Edit, then clear the check box "Display this number of decimal places".
Does that help?
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.
