Not sure what your needs are.

Some measurements can be converted using the CONVERT function found in the
Anaalysis Toolpak.

I do not believe Stones is included so you would have to roll your own
conversion.

What units would you want to convert to stones and pounds?

This formula will give you stones and pounds from Kg

=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&" lbs"


This UDF will convert pounds to stones.

Function Stones(NumberArg As Double) As Double
If NumberArg < 0 Then
Exit Function
Else
Stones = 0.071429 * NumberArg
End If
End Function


Gord Dibben MS Excel MVP

On Tue, 2 Oct 2007 15:26:01 -0700, Carl07
wrote:

How can i use different units of measure within excel? I want to use
measurements of Mass ie Stones and Pounds. Is this possible? If so, can
anyone help me on how to use this? Any help is much appreciated. Thank you.