formatNumber output is incorrect

Welcome to the Make community!

There is probably formatting in Sheets itself, and Sheets has automatically converted the format for you.

To prevent this, select Unformatted “YES”:

Screenshot_2024-08-19_140834

Hope this helps! Let me know if there are any further questions or issues.

@samliew


P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!