Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Where to get a batting average spreadsheet for Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-02-2012
Member
 
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.

Reply With Quote
  #2  
Old 17-02-2012
Member
 
Join Date: Jul 2011
Posts: 428
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.
Reply With Quote
  #3  
Old 17-02-2012
Member
 
Join Date: Jul 2011
Posts: 431
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Where to get a batting average spreadsheet for Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Need help to calculate Average of time in Microsoft Excel NardO MS Office Support 2 23-02-2012 04:06 PM
How to choose all images at a time in Microsoft Excel Spreadsheet NardO MS Office Support 2 23-02-2012 11:16 AM
Font colors are not working in Microsoft Excel Spreadsheet Akolekar MS Office Support 2 15-02-2012 07:03 PM
Who knows about origin of a Microsoft Excel Spreadsheet vALaNCiA MS Office Support 3 07-02-2012 04:58 PM
How to calculate the average time in excel Rao's Windows Software 1 06-01-2012 09:48 PM


All times are GMT +5.5. The time now is 06:50 AM.