How do I send decimal numbers to google sheet?

Hello, I need some help. I have a textbox on my app that reads the average of some spiners, I want to send this number to google sheets but when the number at the textbox is 0.09091 at the google sheet it appears as 9.091. Thanks

How are you sending the data to google sheets ?

Please show your relevant blocks, scripts etc.

This is the script and the bocks

Hmmm... nothing there that gives any indication why 0.09091 would be converted to 9.091. Check your google sheet is not converting it from a number to a percentage ?

You may need a bit more script to clear any formatting in the row/sheet you append to:

Thanks for the reply! I will try it !

Yes it converts it to a percentage.

Tada....... :slight_smile:

thank you very much!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.