I have the opposite of a fairly standard problem -- how do I force Google Spreadsheet to understand that a value is numeric?
It seemed like using Format > Number should do the right thing, but it did not. For whatever reason, out of 200+ values entered into this spreadsheet, all numbers under 40,000, the spreadsheet only understood one to actually be a number. For the rest, isnumeric() returned false, and no amount of cutting & pasting helped.
I did resolve the problem, by creating a new column and using the value() function. The question is, shouldn't there be an easier way?