# Converting weight measurements

#### kelly1

##### Well-known Member
I need a formula to convert kilograms to stones, pounds and ounces.

For the benefit for people outside of the UK, there are 16 ounces in a pound, and 14 pounds in a stone.

Thanks for any help

Kelly

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You want a break down of each unit or of a total? Like...

1000kg = 2204.623 lb, or 35273.972 ou, or 157.4730653 stones?

Good morning kelly

Go to Tools > Add-Ins and select Analysis ToolPak.

Not much will seem to have happened, but you'll have a new function (amongst other things) in your arsenal called CONVERT.

If you have your kilos (1000) in A1, then this formula in A2 will return 2204.623 (pounds):

=CONVERT(A1,"g","lbm")*1000

If you want to show it in stones and pounds (and remember that this looks better but you will lose "addibility") then put this formula in A3:

=ROUND((A2/14),)&" Stones and "&ROUND(MOD(A2,14),)&" pounds"

You could take it even further to show ounces but you get the idea.

HTH

DominicB

Sorry I haven't replied sooner I've been out all day

Thanks for the help

Kelly

Replies
7
Views
273
Replies
1
Views
258
Replies
7
Views
811
Replies
16
Views
371
Replies
2
Views
75

1,203,612
Messages
6,056,301
Members
444,858
Latest member
ucbphd

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back