negative numbers formatted as text

spartner

I am using the JSON string below to add rows to a sheet via the API

However if the value is negative, as in this case, the value is entered as a string rather than a number so -9987.5 becomes '9987.5

Positive values work just fine

I believe something has changed recently as this didn't happen before. How can I specify that the number be treated as a number and not a string

[

  {

    "cells": [

     {

        "value": "-9987.5",

        "strict": false,

        "columnId": 3952583094101892

      }

    ],

"format": ",,,,,,,,,,,,,,2,,",

    "parentId": "6622467836563332"

  }

]

Paul Newcome

Have you tried removing the quotes from around the number?

Paul Newcome

Have you tried removing the quotes from around the number?

spartner

Thanks. I should have thought of that

Paul Newcome

Happy to help. 👍️