negative numbers formatted as text


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"



Best Answer