Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Why does Excel round off numbers?
I balance my checkbook on excel 2010. It insists on rounding off amounts I enter. Like if I wrote a check for $74.05, it will enter $74. Even say $52.36, it may or may not do it. seems to be based on how fast you enter data from the previous amount you enter. If I was doing this for work, it would be a disaster.
4 Answers
- Anonymous1 decade agoFavorite Answer
You have to edit the cell properties to include the decimal amounts.
Right click the cell(s) and go to Format Cell, click numbers, then from the list go to currency. Tell it 2 decimal places
- ?Lv 44 years ago
If i understand what you're attempting to do: There are 2 buttons interior the toolbar, one is for exhibiting one greater decimal form (advance Decimal) and one to coach one decimal form much less (shrink Decimal). In Excel 2003, it is placed interior the main substantial toolbar above the sheet, and in 2007, it is in "living house" tab of toolbar, the "form" area. It feels like this: .00 ->0
- Anonymous1 decade ago
you can change this by increasing the number of decimal places it displays. it should be a little button with an arrow to the right and .00 and .0 all within the button. it's just a default setting sometimes.
hope that helps :)