' before number in google sheet

[ipazin]

Hello @phil21oo,

check this topic:

Google API: Sheets updater saves values as strings

Hi, I’ve uploaded data into Google Sheets via the Google Sheets Updater and noticed values like doubles are inserted with a trailing ’ rendering the data i.e. in a pivot unusable. Any idea how to not append a trailing ’ ? Thanks a lot Mike

Br,
Ivan