Earlier today, I was working with a Google Spreadsheet that contained a column of numbers. In one row I entered 50Yd, which the Spreadsheet formatted as text. No surprise there. In another row I entered 10ft, which Google reformatted as 10 Ft and right aligned like a number.
See this example:
See, =isnumber(10ft) is true.
Is it just me, or did Google detect the units on this number? All the other suffixes I tried (in, yd, mi) seemed to fail to trigger this capability. I was really hoping that I could add up various units and have the spreadsheet do the correct math. But alas, this doesn't work. Yet.
A randomly anomaly? Easter egg? Indication of what's to come? What do you make of it?