Formula To Convert Lbs Into Lbs And Oz

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

Free Excel Help Forum

- Ask any question about Excel and have it answered in no time.

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 ...
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 ...
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 ...
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 ...

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
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
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
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
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

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.


I am looking or a formula that will take decimal pounds and display pounds-ounces, not even sure that excel can display pounds-ounces. 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 1lb-6ozs


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!


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.

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!

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

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:

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
=MROUND(H4/25.4, 1/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.













































I need to convert hundreds of XLS files to TXT. I am aware of File/Save-as
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.


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

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?

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.


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

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.
If you have any problem I have put my email on the web page.


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
i need to convert to 1.035



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?



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



I have made a calculator in excel and now want to upload it to my website so that it functions like the following link

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.


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


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.


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).