For the cost amount, get the numeric value

Thousand separators and decimal marks caused troubles.

Also good to know, from https://developers.google.com/google-apps/spreadsheets/#working_with_cell-based_feeds

> If the cell contains a formula, the calculated value is given here.