British measurements stone and pounds

Hi Oscar,

Be wary of changing to US measurements, because US and UK measurements can differ.

Spreadsheets work on the decimal system (base 10) but we can use workarounds to base 12 for feet and inches, or base 14 for stones and lbs. Example to sum feet and inches:

Some rows and columns were hidden to make a neat presentation.

This is what is happening "behind the curtain" when all rows and columns are unhidden:

One Header Row and two Footer Rows.

Enter Feet and Inches in separate columns B and C

Formula in D2 (for humans to read) is B2&"'"&C2&"''" (and Fill down)

Formula in Footer Cell B5 is SUM(B)

Formula in Footer Cell C5 is SUM(C)

Formula in Footer Cell D5 (for humans to confirm) is B5&"'"&C5&"''"

Formula in Footer Cell B6 is B5+INT(B5÷12)

Formula in Footer Cell C6 is MOD(C5,12)

Formula in Footer Cell D6 (for humans to read) is B6&"'"&C6&"''"

For stones and lbs, change 12 (inches in a foot) to 14 (lbs in a stone).

Formula in B6 is now B5+INT(B5÷14)

Formula in C6 is now MOD(C5,14)

Regards,

Ian.

OscarLegend wrote:

In the settings you can change UK measurements but it uses:

cm for height

kg for weight

(we use feet and inches & stone and lbs)

can change this to feet and inches by switching to US measurements but then the weight is in lbs.

Surely there is a way I can change UK settings to the actual measurements we use.

Any advice?

Is this a Numbers app question? Those are not data formats in Numbers nor are they settings in Numbers->Preferences and I don't see them in the region settings of System Preferences either. It appears you are referring to another app. Maybe a health app?