Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
    
Could you give some examples of numbers that fail, all the values I try work and isnumber() returns TRUE or has the cell got a formula in it? –  parkydr Apr 22 '13 at 20:02
    
I'd have to undo what I'd done and create a new Google Doc from it. I'm not completely sure how the data got in there in the first place (Excel import?), since one of my coworkers created the spreadsheet. When I made a new column and typed in numbers, I got the same results you did. –  khedron Apr 23 '13 at 2:43
1  
Given the 40,000 cut off mentioned I'd suspect a date serial may have been involved. –  pnuts Feb 16 at 9:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.