No matter the number is 1/2/3…，the result of formatNumber Founction is always two decimal placesmal places.
Any help will be greatly appreciated~
Hi,
It could be related to column format of Google Sheets document.
Try manually to insert a number to the cell to see what happens.
If it works - you can add SetVariable module to see the output of formatNumber function
Welcome to the Make community!
You can also try expanding the “Show Advanced Settings” toggle at the bottom and try other “Value input option” or “Insert data option” options.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Thanks for your help 
After entering a float point number in a cell, the number of decimal places can be directly displayed according to the number entered. If I use the function directly in the google sheet, the number of decimal places will also be directly displayed without change. It really confused 
No problem, glad I could help!
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
- others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
2 Likes