title: Dollar symbol not getting summed in Google spreadsheet
body: <p>I want to manage my expenses using a google spreadsheet. The problem is that I use dollars and euros. I write the numbers like $23 and €25. The sum function works properly for the euro symbol, but it returns zero for the $ sign.</p>
  
  <p>I set up a small example here:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1_mg6xxsae2ybDHXQAqGLddXmJMDsYaaGkkhRY2YIIQc/edit#gid=0" rel="nofollow">https://docs.google.com/spreadsheets/d/1_mg6xxsae2ybDHXQAqGLddXmJMDsYaaGkkhRY2YIIQc/edit#gid=0</a></p>
  
  <p>Both columns has the same sum function, but only one works. Why?</p>
  
  <p>Thanks in advance.</p>
  
  <p>---EDIT:
  I updated the example with some data of the real world. And I changed the timezone of the spreadsheet to the one that corresponds to me (spain). I highlighted two examples in the sheet2. As you can see, the examples are using the correct currency format, but the sum stills zero. The same configuration in the sheet1 works nicely.</p>
  
  <p>I'm starting to think the problem is the timezone of the spreadsheet. </p>