Formula To Convert Lbs Into Lbs And Oz 
New Excel Help Service!
We need your input to help create a new Live Online Excel Help service.
Please take our survey and let us know your thoughts!
Have a great day!
Don


Formula To Convert Lbs Into Lbs And Oz  Excel 
View Answers 
I have a weight in D8 in pounds, 2.5, how can I convert this into lb. and oz., 2 lb 8oz
Using excel 2003
Thanks
Using excel 2003
Thanks
Similar Excel Tutorials
Quickly Convert Formulas into Their Output Values in Excel
This tutorial teaches you how to convert a formula or function into its displayed output in Excel. This is very im ...
This tutorial teaches you how to convert a formula or function into its displayed output in Excel. This is very im ...
Convert Scientific Notation to Numbers in Excel
How to convert scientific numbers to show their full amount; this method also allows you to retain the appearance o ...
How to convert scientific numbers to show their full amount; this method also allows you to retain the appearance o ...
Change Minutes from a Decimal to a Percentage of an Hour
Change minutes stored as a decimal into a fraction of an hour. For instance, if time is stored as 8.15, 8 hours and ...
Change minutes stored as a decimal into a fraction of an hour. For instance, if time is stored as 8.15, 8 hours and ...
Remove Table Format in Excel
Convert a table back into a regular set of cells. This removes any automated table features and I'll show you how ...
Convert a table back into a regular set of cells. This removes any automated table features and I'll show you how ...
Convert Column Number to Letter Using a Formula in Excel
How to get a column letter from a number in Excel using a simple formula. This is an important thing to be able to ...
How to get a column letter from a number in Excel using a simple formula. This is an important thing to be able to ...
Make Negative Numbers Positive in Excel and Vice Versa
I will show you a few ways to change negative numbers to positive numbers and back again in Excel. Don't forget to ...
I will show you a few ways to change negative numbers to positive numbers and back again in Excel. Don't forget to ...
Helpful Excel Macros
Convert Numeric Dollar Values into Text in Excel  UDF
 Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or tra
 Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or tra
Replace Formulas with Values (For The Entire Workbook)
 This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
 This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
Hide Formulas in a Worksheet and Prevent Deletion
 This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
 This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
Determine if a Cell Contains a Function in Excel  Great for Conditional Formatting and Validation  UDF
 Determine if a cell in Excel contains a formula or function with this UDF (user defined function). This function return
 Determine if a cell in Excel contains a formula or function with this UDF (user defined function). This function return
Name Worksheets Based on Cell Contents
 This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
 This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
Similar Topics
Hello, could someone please give me a little help. What I want to do is convert a weight from kilograms to stones & pounds. So say in cell C5 I will have a weight in kilograms, say 72, then in cell C6 I want it to display that weight in stones & pounds, which should convert as 11 stone 5 pounds. I just need the formula that will do the conversion.
Thank you.
Thank you.
Hello,
I am looking or a formula that will take decimal pounds and display poundsounces, not even sure that excel can display poundsounces. I am fairly good with formulas but beyond add, subtract, multiply and divide I am clueless.
A very simple example of what I am looking to do:
cell A1 is entered as 1.5
I want a formula in cell A2 that will display 1lb6ozs
TIA
aart
I am looking or a formula that will take decimal pounds and display poundsounces, not even sure that excel can display poundsounces. I am fairly good with formulas but beyond add, subtract, multiply and divide I am clueless.
A very simple example of what I am looking to do:
cell A1 is entered as 1.5
I want a formula in cell A2 that will display 1lb6ozs
TIA
aart
i have a spreadsheet with months on and i have added the expenses for each month, and i have cell a1 with the year total (euros) in it, i want to make cell a2 convert in gb pounds, how can i do that please
G'day guys,
Pretty much a novice when it comes to Excel, but I'm hoping you can help me out here.
What I want is to enter my weight in stones and pounds into one cell, then in another cell have that converted to kgs so I can display a chart.
I've tried a few things, but nothing working thus far. Any suggestions greatly appreciated!
Thanks,
Thommo
Pretty much a novice when it comes to Excel, but I'm hoping you can help me out here.
What I want is to enter my weight in stones and pounds into one cell, then in another cell have that converted to kgs so I can display a chart.
I've tried a few things, but nothing working thus far. Any suggestions greatly appreciated!
Thanks,
Thommo
I am attempting to use Excel to track my ongoing weight loss. I have an artificial heart valve and my cardiologist has advised me not to lose more than 1 pound a week lest I put strain on my valve.
In my spreadsheet:
Column A is dates. (I put the date I weigh myself here.)
Column B is my weight in pounds.
I would like to know my average weekly change in weight (in pounds).
Any help you can provide would be greatly appreciated.
In my spreadsheet:
Column A is dates. (I put the date I weigh myself here.)
Column B is my weight in pounds.
I would like to know my average weekly change in weight (in pounds).
Any help you can provide would be greatly appreciated.
I'm trying to write a spreadsheet to calculate the pounds and ounces of different foods to feed my dog, cat, and kitten, based on their weight.
In this thread Marcol helped another poster with a spreadsheet for figuring weights of fish, but when I opened it, the formulas would not display.
Attached is my spreadsheet so far. It's got values in kilograms but my scale only weighs pounds and ounces.
Thanks for helping!
In this thread Marcol helped another poster with a spreadsheet for figuring weights of fish, but when I opened it, the formulas would not display.
Attached is my spreadsheet so far. It's got values in kilograms but my scale only weighs pounds and ounces.
Thanks for helping!
I am trying to convert a column of numbers into hours:minutes:seconds.
For example, I have following numbers (original data followed by desired output). I tried using the custom number format but could not get the desired result. Any assistance appreciated.
9  convert to :09
53  convert to :53
68  convert to 1:08
109  convert to 1:49
121  convert to 2:01
262  convert to 4:22
For example, I have following numbers (original data followed by desired output). I tried using the custom number format but could not get the desired result. Any assistance appreciated.
9  convert to :09
53  convert to :53
68  convert to 1:08
109  convert to 1:49
121  convert to 2:01
262  convert to 4:22
I'm very, very new to Excel, and I need to create my own BMR (Basal Metabolic Rate) calculator for a project at work. I'm very confused by the formula builder.
Here's the formula:
BMR=
Women: 655 + (4.35 x weight in pounds) + (4.7 x height in inches)  (4.7 x age in years)
Men: 66 + (6.23 x weight in pounds) + (12.7 x height in inches)  (6.8 x age in years)
I don't understand how to set it up to make the proper calculations. Is there a step by step tutorial for this?
Thanks in advance!
P.S.  I'm using Excel 2008 for Mac
Here's the formula:
BMR=
Women: 655 + (4.35 x weight in pounds) + (4.7 x height in inches)  (4.7 x age in years)
Men: 66 + (6.23 x weight in pounds) + (12.7 x height in inches)  (6.8 x age in years)
I don't understand how to set it up to make the proper calculations. Is there a step by step tutorial for this?
Thanks in advance!
P.S.  I'm using Excel 2008 for Mac
I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction
for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
Good afternoon, everyone. I am in charge of a bar here in deep south texas. I need help in creating an Excel file that will automatically convert the weight of a keg, to how much beer is in the keg (we call this COUNT). In the example below is the chart that I currently use. I would like to put in the weight of the keg, and excel to give me the count. Any help would be greatly appreciated. Thank you in advance.
Weight
Count
161
FULL
154.5
0.95
147.9
0.9
141.4
0.85
134.8
0.8
128.3
0.75
121.7
0.7
115.2
0.65
108.6
0.6
102.1
0.55
95.5
0.5
89
0.45
82.4
0.4
75.9
0.35
69.3
0.3
62.8
0.25
56.2
0.2
49.7
0.15
43.1
0.1
36.6
0.05
30
EMPTY
Weight
Count
161
FULL
154.5
0.95
147.9
0.9
141.4
0.85
134.8
0.8
128.3
0.75
121.7
0.7
115.2
0.65
108.6
0.6
102.1
0.55
95.5
0.5
89
0.45
82.4
0.4
75.9
0.35
69.3
0.3
62.8
0.25
56.2
0.2
49.7
0.15
43.1
0.1
36.6
0.05
30
EMPTY
I need to convert hundreds of XLS files to TXT. I am aware of File/Saveas
and I also tried written a macro. Neither solution is workable even the
number of files I have to convert. Does Excel have a mass convert utility?
and I also tried written a macro. Neither solution is workable even the
number of files I have to convert. Does Excel have a mass convert utility?
Copy of Bar loader kilos & pounds.xls
I am tryng to create a a bar loading program that will allow me to type in a kilo weight and have returned the number of plates needed to be able to load the bar to that weight. The reason I attatched the document above is to show you what I am talking about rather than trying to describe it. My only issue is I want a cell that I can enter the weight in, rather than sliding the slider up and down to control the weight. The problem is I have no idea where to start as I don't know what formulas to use. I am not looking for someone to do it for me, simply to point me in the right direction. Thank you.
I need a formula that will convert degrees Lat/Long to hours minutes seconds.
Example:
32.53042 92.0901
Need to convert to:
32 31 49.5114 92 5 24.36 (With spaces in between)
Example:
32.53042 92.0901
Need to convert to:
32 31 49.5114 92 5 24.36 (With spaces in between)
how do I get a cell to show Stones & Pounds (Weight) from Pounds?
In other words, if I put in 222 lbs, I want a cell to show this in Stones & Pounds
In other words, if I put in 222 lbs, I want a cell to show this in Stones & Pounds
I need to keep a running total of weight, in pounds and ounces, for 12
months. I'd like to add 6.02 (6lbs 2ozs), 9.13 (9lbs 13 ounces)etc and be
able to total 12 different numbers. How do I get the number to recognize
16ozs as 1 pound? Is there a better way?
months. I'd like to add 6.02 (6lbs 2ozs), 9.13 (9lbs 13 ounces)etc and be
able to total 12 different numbers. How do I get the number to recognize
16ozs as 1 pound? Is there a better way?
Can anyone help me with this?
I have over 500 Grid ref locations that I wish to convert to Long & Lat
The following Grid ref NO305105 converts to 3.1249666,56.2816999 I have used various web sites which allow you to convert one at a time.
Can I paste my info to Excel and convert to Long & Lat? This will then allow me to convert to Ov2 file for my Tom tom.
Any help greatly appreciated.
Davy
I have over 500 Grid ref locations that I wish to convert to Long & Lat
The following Grid ref NO305105 converts to 3.1249666,56.2816999 I have used various web sites which allow you to convert one at a time.
Can I paste my info to Excel and convert to Long & Lat? This will then allow me to convert to Ov2 file for my Tom tom.
Any help greatly appreciated.
Davy
I want to create a spreadsheet to track weight loss/gain for a number of
people in our office. The gotcha is that we want to work in Stones and pounds
(1Stone=14Lb). I would like to be able to calculate differences between
cells displayed in Stones/Lbs
people in our office. The gotcha is that we want to work in Stones and pounds
(1Stone=14Lb). I would like to be able to calculate differences between
cells displayed in Stones/Lbs
I am trying to find a formula for vlookup and sumif.
I am trying to build a spreadsheet for our drafting dept.
The weights are being calculated by hand. I think it would be easier if we had a spreadsheet.
For example, I have a channel that is C 8 x 11.5 the length is 7ft 6inch. The weight of the channel is .852 pounds per foot. I am able to calculate that in excel and come up with 86 pounds rounded. The material will change every time and the weight of the material will change every time. The length of the material will also change. I can input the length every time. What I want is to create a list where excel will do VLOOKUP and pull a different item every time something is typed in.
I have put the spreadsheets on my web page. www.mykaltx.com.
If you have any problem I have put my email on the web page.
I am trying to build a spreadsheet for our drafting dept.
The weights are being calculated by hand. I think it would be easier if we had a spreadsheet.
For example, I have a channel that is C 8 x 11.5 the length is 7ft 6inch. The weight of the channel is .852 pounds per foot. I am able to calculate that in excel and come up with 86 pounds rounded. The material will change every time and the weight of the material will change every time. The length of the material will also change. I can input the length every time. What I want is to create a list where excel will do VLOOKUP and pull a different item every time something is typed in.
I have put the spreadsheets on my web page. www.mykaltx.com.
If you have any problem I have put my email on the web page.
Hi,
Can someone help me, what i need is some vba code to convert a price with a fraction in it to a decimal figure.
Eg in cell A1 you have 1.03 1/2
B1 56.05 47/64
ect
i need to convert to 1.035
thanks
Mark
Can someone help me, what i need is some vba code to convert a price with a fraction in it to a decimal figure.
Eg in cell A1 you have 1.03 1/2
B1 56.05 47/64
ect
i need to convert to 1.035
thanks
Mark
Hi,
I have a large spreadsheet in pdf format that I want to convert to Excel. I have tried several programmes that will extract the data (not the charts), and will dump it into a worksheet, however all formatting and formulas are gone.
It will take days to have to try & work out all the formula links. Does anyone know of a programme you can use to convert all the data from a pdf into Excel including most importantly the formulas?
Thanks
I have a large spreadsheet in pdf format that I want to convert to Excel. I have tried several programmes that will extract the data (not the charts), and will dump it into a worksheet, however all formatting and formulas are gone.
It will take days to have to try & work out all the formula links. Does anyone know of a programme you can use to convert all the data from a pdf into Excel including most importantly the formulas?
Thanks
Hi,
I am working with a spreadsheet of names and addresses. The data was entered in lowercase but I would like to convert it all to uppercase. I have tried the UPPER function, but that does not seem to convert text already entered within the same cell. I am looking for a solution that would allow me to convert all the cells as they are without have to cut and paste. Any ideas?? :o
Thanks!
Linda
I am working with a spreadsheet of names and addresses. The data was entered in lowercase but I would like to convert it all to uppercase. I have tried the UPPER function, but that does not seem to convert text already entered within the same cell. I am looking for a solution that would allow me to convert all the cells as they are without have to cut and paste. Any ideas?? :o
Thanks!
Linda
Hi
I have made a calculator in excel and now want to upload it to my website so that it functions like the following link
http://www.agchieve.ca/calc/calc_code_example.html
How to I do this? How do I convert this excel sheet into a web form where users can manipulate the figures?
I currently use excel 2003 and 2007.
Thanks!
I have made a calculator in excel and now want to upload it to my website so that it functions like the following link
http://www.agchieve.ca/calc/calc_code_example.html
How to I do this? How do I convert this excel sheet into a web form where users can manipulate the figures?
I currently use excel 2003 and 2007.
Thanks!
I am trying to find a formula that will convert existing number combinations
into corresponding letter combinations in Excel. The relationship of numbers
to letters is as follows:
1 = A 6 = F
2 = B 7 = G
3 = C 8 = H
4 = D 9 = I
5 = E 0 = J
For example, I'd like to convert a cell that contains '1250' to 'ABEJ'
I've had no success with the HELP feature in Excel.
Thank you for any help you may provide
Jason
jplazola@yahoo.com
into corresponding letter combinations in Excel. The relationship of numbers
to letters is as follows:
1 = A 6 = F
2 = B 7 = G
3 = C 8 = H
4 = D 9 = I
5 = E 0 = J
For example, I'd like to convert a cell that contains '1250' to 'ABEJ'
I've had no success with the HELP feature in Excel.
Thank you for any help you may provide
Jason
jplazola@yahoo.com
Hello,
I am trying to convert 12 digit decimal numbers to binary; example, convert 530070378301 to 111101101101010101010000001011100111101. I have found many examples for conversions but nothing that will convert anything this large.
Any help would be much appreciated.
Regards,
Jarrod
I am trying to convert 12 digit decimal numbers to binary; example, convert 530070378301 to 111101101101010101010000001011100111101. I have found many examples for conversions but nothing that will convert anything this large.
Any help would be much appreciated.
Regards,
Jarrod
which formula I use for number or currency convert into text or words
like ($10220.00) convert into (Ten Thousand Two Hundred Twenty US Dollars &
Zero Cents Only).
like ($10220.00) convert into (Ten Thousand Two Hundred Twenty US Dollars &
Zero Cents Only).