Hi Guys Isn't there a way to read "1 000" as "1000" in Google sheets?
I've got hundreds of data entries, and Google sheets gives me the error: "Function ADD parameter 1 expects number values. But '22 166.19' is a text and cannot be coerced to a number." CERTAINLY it can be coerced to a number if you just ignore the thousand separator. So is there a way I can get sheets to ignore the space for the thousand separator? Also, why is there so little traffic about this problem online? On Monday, 7 December 2009 07:17:09 UTC+2, Albert C wrote: > > Hello! > I have managed to extract data from a spreadsheet with this query, > which works great. > > http://spreadsheets.google.com/tq?tqx=out:html&tq=select O,C, sum (H) > group by O,C order by O desc limit 20 label sum (H) > "Ventas"&key=tZrsLGPo9h-dPJeCPXs4_ww&pub=1 > > HOWEVER, I have an issue with localization. Depending on the browser I > use (IE in Spanish, Firefox in English), it swaps dots and commas for > decimal and thousands separators. Is there a way to override the > browser language and always use the English localized settings? (Dot > for decimals, Comma for thousands) > > Thank you in advance, > > Albert C > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/27c3c936-295b-4c0d-95e6-680690fcee88%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
