title: Why does gspread keep adding semicolons in front of floats?
body: <p><strong>Expected behaviour:</strong></p>
  <p>Values are written to worksheet cells as floats because they are floats.</p>
  <p><strong>Actual behaviour:</strong></p>
  <p>Sometimes floats end up with a mysterious semicolon in front of them, which isn't possible as if there was a semicolon the program would return errors since the values are converted to floats and that wouldn't be possible for a semicolon. Printing the values doesn't show an extra semicolon in front of the values.</p>
  <p><strong>Errors:</strong></p>
  <p>None, except for the worksheet which as a result of all this cannot divide with the values so I naturally end up with a <code>#DIV/0</code> error which is expected.</p>
  <p><strong>Details</strong></p>
  <p>So I'm having this seemingly random problem with gspread where it sometimes adds a semicolon in front of values (from what I can tell only floats), which really messes with my worksheets as they do equations based on these values and I constantly end up with 0div errors because they aren't floats in the worksheets.</p>
  <p>I use <code>sheet.update(range, values)</code> to write data to the sheet and the values in the data are converted to floats on several occasions just to be sure they'd stay that way. The problem is in no way consistent it can vary cell by cell and worksheet by worksheet but it's still frustrating.</p>
  <p>For reference here's an example worksheet:
  <a href="https://i.stack.imgur.com/V1Vw8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V1Vw8.png" alt="enter image description here" /></a></p>
  <p>When I print the row values it looks like this (no semicolons there):
  <a href="https://i.stack.imgur.com/XZVug.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XZVug.png" alt="enter image description here" /></a></p>
  <p>I would really appreciate input on this as I have no clue what's happening - is this something usual with gspread? And I should add that I can't use integers instead of floats as the values can be floats - they just don't have decimals in that particular example.</p>