Dropsafe

by Alec Muffett

Converting Millimeters to Feet & Decimal Inches in Google Sheets

2022/06/04 15:03:14 BST

This works for me:

=to_text(int(B5/304.8))&"ft "&text((mod(B5,304.8)/25.4),"0.00")&"in"

google sheets imperial metric spreadsheets

Comments

Leave a Reply Cancel reply

More posts

“You can tell by the way complaints or requests are worded that they have used AI technology to be able to ask for that information,” he said

2026/05/31
Using AI to assist interpretation…

2026/05/30
Govt: “We committed in the Violence Against Women and Girls Strategy ‘to make it impossible for children in the UK to take, share or view a nude image.’”

2026/05/29
HOW ABOUT SIMPLY NOT HANDING YOUR CHILD A SMARTPHONE, JESS?

2026/05/28