Excel question - Fantasy Baseball Cafe 2014

## Excel question

Moderator: Baseball Moderators

### Excel question

Doing some projections for my baseball stuff. Learned a lot about the forumlas on various websites. But, I couldn't find anything on rounding fractions up to the last three numerals. You know, 0.333 for example. Any help guys?

Thanks
 Broncmet724
Major League Manager

Posts: 1754
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

Right-click on any cell you want rounded, choose "Format Cells" from the menu, and click the "Numbers" tab (it should be the one on the far left). Select "Number" from the list on the left, and choose the number of decimal places you want the cell to show on the option area to the right.
Keep wreves in General Talk in 2011!
knapplc
Hall of Fame Hero

Posts: 7871
(Past Year: 1)
Joined: 27 Dec 2004
Home Cafe: Football
Location: It's "ell see." ELL SEE!!!

Select and right-click the cell(s)

Format Cells

Under Number, choose number and set the # of decimal places
roninmedia
Major League Manager

Posts: 1647
Joined: 16 Jul 2003
Home Cafe: Baseball

knapplc wrote:Right-click on any cell you want rounded, choose "Format Cells" from the menu, and click the "Numbers" tab (it should be the one on the far left). Select "Number" from the list on the left, and choose the number of decimal places you want the cell to show on the option area to the right.

It's also easy if say, you wanted an entire row or column to round up to a desired number of decimals...you select the row or column (on the left hand side or on the top side, respectively) and do the same procedure. That way, you never have to keep formatting the cells individually. If you really want to be a smarty-pants, just use the keystroke Ctrl-1 (or Apple-1 in Mac) to Format Cells.
The Artful Dodger
Chief Wikitect

Posts: 21939
(Past Year: 675)
Joined: 3 Feb 2006
Home Cafe: Baseball

The Artful Dodger wrote:
knapplc wrote:Right-click on any cell you want rounded, choose "Format Cells" from the menu, and click the "Numbers" tab (it should be the one on the far left). Select "Number" from the list on the left, and choose the number of decimal places you want the cell to show on the option area to the right.

It's also easy if say, you wanted an entire row or column to round up to a desired number of decimals...you select the row or column (on the left hand side or on the top side, respectively) and do the same procedure. That way, you never have to keep formatting the cells individually. If you really want to be a smarty-pants, just use the keystroke Ctrl-1 (or Apple-1 in Mac) to Format Cells.

I typically format one cell then use the Format Painter to copy that format to other cells. You can use the Format Painter on entire sections, too, which is nice if you want to create a section for each team in your league. You can copy/paste the headers, change the team name in each section, and copy the format of the stats you want from section to section.

Excel rocks. Plain and simple.
Keep wreves in General Talk in 2011!
knapplc
Hall of Fame Hero

Posts: 7871
(Past Year: 1)
Joined: 27 Dec 2004
Home Cafe: Football
Location: It's "ell see." ELL SEE!!!

Look for the little button with:

-an arrow... either right or left.
-zeroes... and decimal points.

Push the correct one until you reach the desired round.

[b]Thanks Franchise for the sig!

The [url=http://www.fantasybaseballcafe.com/forums/viewtopic.php?p=2014799#2014799]CTU Agents[/url] of the Aces High Cafe Challenge League.[/b]
 danleroi22
Minor League Mentor

Posts: 458
Joined: 14 Jun 2004
Home Cafe: Football
Location: A Marlins Fan... in Ray Country

Thanks for the help guys
 Broncmet724
Major League Manager

Posts: 1754
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

Broncmet724 wrote:Thanks for the help guys

[b]Thanks Franchise for the sig!

The [url=http://www.fantasybaseballcafe.com/forums/viewtopic.php?p=2014799#2014799]CTU Agents[/url] of the Aces High Cafe Challenge League.[/b]
 danleroi22
Minor League Mentor

Posts: 458
Joined: 14 Jun 2004
Home Cafe: Football
Location: A Marlins Fan... in Ray Country

Just wanted to point out that there are also functions: Round, RoundUp, RoundDown. In most cases I just use formatting like the guys above outlined but there is a difference since the formatted value has a different real value. If you do calculations that depend on the rounding you need to use the functions.

Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

### Who is online

Users browsing this forum: No registered users and 5 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Wednesday, Sep. 3
(All times are EST, weather icons show forecast for game time)

 • Pittsburgh at St. Louis(1:45 pm)
 • San Francisco at Colorado(3:10 pm)
 • Washington at LA Dodgers(3:10 pm)
 • Seattle at Oakland(3:35 pm)
 • Boston at NY Yankees(7:05 pm)
 • Detroit at Cleveland(7:05 pm)
 • Cincinnati at Baltimore(7:05 pm)
 • NY Mets at Miami(7:10 pm)
 • Toronto at Tampa Bay(7:10 pm)
 • Milwaukee at Chi Cubs(8:05 pm)
 • LA Angels at Houston(8:10 pm)
 • Texas at Kansas City(8:10 pm)
 • Chi White Sox at Minnesota(8:10 pm)
 • Arizona at San Diego(10:05 pm)