1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to make Excel just keep 2 decimal place behind comma after executing function?

Hello, I recently downloaded Solver and Data Analysis tool pack and it changed the decimal place especially in percentage. Usually with excel, after for example executing =a%/b%, I will receive number with maximum 4-6 decimal place behind the comma. However recently, it starts giving me numbers up to 15 decimal place behind the comma. How to solve this for entire book without using trunc or something else? I just want to keep it to 2 decimal place behind the comma for the whole file but it always automatically gives more than 2 decimal behind place. I have checked option > advance, googled it but no avail. My excel is 2021 version, english, and I'm just beginner who is stressed about this. Thank you in advance.

submitted by /u/chipotatochip
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#conversational data analysis
#financial modeling with spreadsheets
#data analysis tools
#rows.com
#big data management in spreadsheets
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data cleaning solutions
#Excel
#decimal place
#2 decimal place
#percentage