Hi, how do i get rid of all the 0.01 difference in excel?
For example, A1 and A2 and A3 all =1/3. All will show 0.33 if i format cell n make it show 2 decimal places. However, if i sum it up. It shows 1 instead of 0.99. The only way to solve this is to use the round formula. Example round((1/3,2)). However, its very troublesome to manually insert all the round formula into all the cell because i hava a very huge data.
Is there a way to highlight the entire row and format cell to do that?
Bookmarks