America has two feet … does Excel?

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Did you know that the U.S has two feet?  Meaning two different measurements for the term ‘foot’? That got us wondering how Excel’s Convert() handled the standard ‘foot’ and the US Survey ‘foot’.

Excel Convert() supports the International Standard Foot but not, directly, the US Survey Foot.

America Has Two Feet. It’s About to Lose One of Them tells the story of the two versions of ‘foot’ in the USA and the confusion that causes.

The standard Foot is used by almost everyone except some land surveys which use the US Survey Foot.  In some cases a building height is measured in a standard feet while it’s land coverage is in US Survey Feet.

The older Survey foot is slightly longer than the standard foot.

Basic two feet comparisons

The difference between the standard foot and the US Survey foot is tiny and only starts to matter for long measurements.

One US Survey foot equals

1.000002000004000008000016000032 standard feet or

0.30480060960122 meters

One standard foot equals

0.99999713057917  US Survey feet or

0.304799735 meters

Excel and the US Survey Foot

Turning to Excel, which as a Convert() function to do conversions between many different measurements.

Annoyingly, Excel’s Convert() does NOT have the US Survey Foot but it does have the US Survey Mile.

image 3 336x296 - America has two feet … does Excel?

How to get the US Survey Foot in Excel

The US Survey Mile is 5,280 US Survey Feet (which fits because a standard mile is 5,280 standard feet).

To get a US Survey foot measurement, multiply a US Survey Mile result from Excel by 5280.

image 5 473x91 - America has two feet … does Excel?

Of course, the rest of the world looks at the two different foot measurements in the USA and says “They are still using feet and not metres?”.

US Survey Mile on Wikipedia

Conversion.org has high precision conversions

The US Survey Foot is being phased out. The NIST has an FAQ about the changeover.

Full CONVERT() measurement list for Excel
Converting Google Sheets to Excel 
Excel convert Range to Array in VBA
Excel’s CONVERT function for metric and more

subs profile e1563205311409 - America has two feet … does Excel?
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address