|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2009, 05:19 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
conversion tables for metric to imperial measurements
I would like a set of conversion tables for metric to imperial measurements
e.g metres to feet, litres to gallons etc for use in excel. Can anyone help? Many thanks 
|
|
#2
May 15th, 2009, 05:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
conversion tables for metric to imperial measurements
See CONVERT in Excel Help.
David wrote: I would like a set of conversion tables for metric to imperial measurements e.g metres to feet, litres to gallons etc for use in excel. Can anyone help? Many thanks
|
|
#3
May 15th, 2009, 05:30 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
conversion tables for metric to imperial measurements
Hi,
Excel has that built in. Look at CONVERT in Excel help. Mike "David" wrote: I would like a set of conversion tables for metric to imperial measurements e.g metres to feet, litres to gallons etc for use in excel. Can anyone help? Many thanks
|
|
#4
May 15th, 2009, 05:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
conversion tables for metric to imperial measurements
To get meter to feet table
Enter meters in Col A starting at A2 Enter this formula in B2 and copy down =A2 * 3.2808399 For litres to gallons enter litres in Col C from C2 and enter this formula in D2 and copy down... =C2 * 0.264172052 or =C2/3.78541178 ..... "David" wrote: I would like a set of conversion tables for metric to imperial measurements e.g metres to feet, litres to gallons etc for use in excel. Can anyone help? Many thanks
|
|
#5
May 15th, 2009, 05:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
conversion tables for metric to imperial measurements
Your 3.78541178 is correct for US gallons to liters
BUT for Imperial gallons the value is 4.54609188 gallons per litres Jefferson (who set up the US system of measures) chose the Queen Anne wine gallon and the Brits opted for the older beer gallon best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sheeloo" wrote in message ... To get meter to feet table Enter meters in Col A starting at A2 Enter this formula in B2 and copy down =A2 * 3.2808399 For litres to gallons enter litres in Col C from C2 and enter this formula in D2 and copy down... =C2 * 0.264172052 or =C2/3.78541178 .... "David" wrote: I would like a set of conversion tables for metric to imperial measurements e.g metres to feet, litres to gallons etc for use in excel. Can anyone help? Many thanks
|
|
#6
May 15th, 2009, 06:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
conversion tables for metric to imperial measurements
Ho-ly-cow. THAT was some serious history lesson. I am printing this one out
next time someone asks. "Bernard Liengme" wrote: Your 3.78541178 is correct for US gallons to liters BUT for Imperial gallons the value is 4.54609188 gallons per litres Jefferson (who set up the US system of measures) chose the Queen Anne wine gallon and the Brits opted for the older beer gallon best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sheeloo" wrote in message ... To get meter to feet table Enter meters in Col A starting at A2 Enter this formula in B2 and copy down =A2 * 3.2808399 For litres to gallons enter litres in Col C from C2 and enter this formula in D2 and copy down... =C2 * 0.264172052 or =C2/3.78541178 .... "David" wrote: I would like a set of conversion tables for metric to imperial measurements e.g metres to feet, litres to gallons etc for use in excel. Can anyone help? Many thanks
|
|
#7
May 15th, 2009, 06:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
conversion tables for metric to imperial measurements
Thanks Bernard,
I knew they were different (but forgot while replying to the post) but I did NOT know the reason... Many thanks... "Bernard Liengme" wrote: Your 3.78541178 is correct for US gallons to liters BUT for Imperial gallons the value is 4.54609188 gallons per litres Jefferson (who set up the US system of measures) chose the Queen Anne wine gallon and the Brits opted for the older beer gallon best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sheeloo" wrote in message ... To get meter to feet table Enter meters in Col A starting at A2 Enter this formula in B2 and copy down =A2 * 3.2808399 For litres to gallons enter litres in Col C from C2 and enter this formula in D2 and copy down... =C2 * 0.264172052 or =C2/3.78541178 .... "David" wrote: I would like a set of conversion tables for metric to imperial measurements e.g metres to feet, litres to gallons etc for use in excel. Can anyone help? Many thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
