Excel spreadsheet help

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   The spreadsheet is free for educational use. The functions used are all in the public domain. All I have done is show how they might be used. You are free to modify, adapt as you wish. BUT I am not responsible for any problems , issues etc that you might encounter using the application!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Admin Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Administrator Joined: 01 Sep 2009 Location: N. Ireland Status: Offline Points: 390	Post Options Post Reply Quote Admin Report Post Thanks(0) Quote Reply Topic: Excel spreadsheet help Posted: 21 Mar 2011 at 8:23pm
	The spreadsheet is free for educational use. The functions used are all in the public domain. All I have done is show how they might be used. You are free to modify, adapt as you wish. BUT I am not responsible for any problems , issues etc that you might encounter using the application!

Sponsored Links

PaulR Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21 Mar 2011 Status: Offline Points: 1	Post Options Post Reply Quote PaulR Report Post Thanks(0) Quote Reply Posted: 21 Mar 2011 at 12:21am
	I have been looking for a spreadsheet to change kilograms to pounds and ounces and found yours at http://www.dairyscience.info/map/converter.xls . Exactly what I needed have you any objections in me using this in our school? Thanks Paul

Admin Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Administrator Joined: 01 Sep 2009 Location: N. Ireland Status: Offline Points: 390	Post Options Post Reply Quote Admin Report Post Thanks(0) Quote Reply Posted: 07 Feb 2011 at 11:18pm
	Joe Thank you for supporting the site. To see the worksheets in a workbook go to "View" on the ribbon, then go to "Arrange all" and finally go to "Arrange horizontal". You should see all the worksheets now. Re; pounds and ounces. I can suggest 2 options. a) using the convert function. The syntax is: = CONVERT(number,"from_unit","to_unit"). Note the requirement for "" around the units. Alternatively use the DOLLARFR function. This can be easily configured to give pounds and ounces (in sixteenths) but it is confusing for many people. The syntax here is =DOLLARFR(number*2.2046,16). A result of 2.02 means 2 pounds and 2 ounces! I have prepared a simple, free spreadsheet to show how this can be done. Click on the image below to download the spreadsheet.

joe91 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 07 Feb 2011 Status: Offline Points: 1	Post Options Post Reply Quote joe91 Report Post Thanks(0) Quote Reply Posted: 07 Feb 2011 at 10:09pm
	Need some help with spreadsheets from the site pl? If I cant see a worksbook (lost it) in Excel 2010 how can I see it? I want to convert kilos to pounds and oz how do I do this in spredsheet without this option. Thanks JFS