Stop excel rounding up to nearest number

**1der** · 03-08-2009, 10:14 AM

I'm new to using excel for my Appliance repair business and not very computer savy, sorry for stupid questions. But when I try to put 62.50 in a cell (??correct term??) it automatically goes the 63 when I shift to next cell(box). I can't keep it from rounding off. Also, when I add numbers in a descending column I have to type EACH number. How to I get it to do this automatically? Example:
1788
1789
1790
1791

**DonkeyOte** · 03-08-2009, 10:46 AM

Re: first question - format the cell(s) to display to 2 decimals (shortcut - press CTRL + 1 -- see Number Tab and then use Number Category to 2 decimals)

Re: second question - use the Fill Handle http://revver.com/video/1355876/exce...bers-and-data/