Results 1 to 3 of 3

Thread: Where to get a batting average spreadsheet for Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    21

    Where to get a batting average spreadsheet for Microsoft Excel

    When a player goes 8/8, how do i stop it from displaying a 1. I tried # ?/8, but i still get a 1. I do not understand what formula to use in this. Is there a ready made template for the same. Any solution on the formula will also be more helpful.

  2. #2
    Join Date
    Jul 2011
    Posts
    441

    Re: Where to get a batting average spreadsheet for Microsoft Excel

    Try this. Format cell like text BEFORE entering data or enter an apostrophe (') in front of data, e.g. '8/8. And for the template you will nee dot check properly on office.microsoft.com. Try searching for the same on the site and then checkback.

  3. #3
    Join Date
    Jul 2011
    Posts
    435

    Re: Where to get a batting average spreadsheet for Microsoft Excel

    If you will not write = sign then it will not do any calculation unless your cell format is date or number format make you cell format as text but if you want calculation on it then you can revert it back. If you're going to use excel to do calculations, put the at bats in one cell and the hits in another. Your calculations will become lots easier. Even if you're not going to calculations now, you may in the future.

Similar Threads

  1. Need help to calculate Average of time in Microsoft Excel
    By NardO in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 04:06 PM
  2. Replies: 2
    Last Post: 23-02-2012, 11:16 AM
  3. Font colors are not working in Microsoft Excel Spreadsheet
    By Akolekar in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 07:03 PM
  4. Who knows about origin of a Microsoft Excel Spreadsheet
    By vALaNCiA in forum MS Office Support
    Replies: 3
    Last Post: 07-02-2012, 04:58 PM
  5. How to calculate the average time in excel
    By Rao's in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 09:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •