Hi Make
I’m trying to export numbers from Google Sheets to a MAKE data store.
Numbers in Google Sheets have the following format: 2.00, 2.01, 2.02, etc.
Numbers ending with one or two zeros after the dot are written to the data store without zeros.
How can I make sure that numbers ending with one or two zeros after the dot are written to the data store in their original form? For example, 2.00, 2.10, etc.
setting the datatype of column as numeric should work. if that does not work you could set it as a string.
Numeric type doesn’t work. Naturally, I tried that.
String? There is no such data type.
i meant to say text instead of string
This doesn’t work either, unfortunately. I have tried all data types.
It is possible to enter data and save them. But after I exit and enter the data store again, the zeros are removed.
As I wrote earlier, I’m trying to export numbers from Google Sheets to a MAKE data store.
When exporting from Google Sheets, this does not work for me. I tried to specify in Google Sheet the data type “Text” for the exported numbers. It didn’t help me.
Try to do with export from Google Sheets please. Does it work for you?
Like i wrote above it works for me. Yes that was the test from a googlesheet. You may have to check your formatting and the output of the googlesheet in make.
Hi Rory,
You can use the Format Number function to format the decimal points on the number. Also, in the datastore keep the field property as the number.
Here is how to apply formatNumber function.
Regards,
Manish Mandot
Need help, visit me here 
I rechecked everything again. Found my little bug in the Data Store module.
Thank you very much for your help!
