Option 1:

Format the cell using the fraction option (2 digits), press ctrl+ 1 to
open the formatting menu, select the number tab, and select the
fraction option.

You can then enter a wight such as "8 10/14".

The downside is that this will be displayed as "8 5/7"

Option 2:
You have to put the Stones and Pounds in seperate columns. say a1 = 8
and b1 = 10 as the start and c1 = 7 and d1 = 13 as the end weight.

The difference is ((c1*14)+d1)-((a1*14)+b1), put this way weight loss
would be negative. Using the above example -11. You could have a cell
to work out the difference using the following:

=IF(((C1*14)+D1)-((A1*14)+B1)<0,"Weight Loss of " &
INT(((((C1*14)+D1)-((A1*14)+B1))*-1)/14) & "St " &
MOD((((C1*14)+D1)-((A1*14)+B1))*-1,14)
&"Lbs",IF(((C1*14)+D1)-((A1*14)+B1)0,"Weight Gain of " &
INT((((C1*14)+D1)-((A1*14)+B1))/14) & "St " &
MOD(((C1*14)+D1)-((A1*14)+B1),14) &"Lbs","No Weight Change"))


HTH

Art


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=345808