Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Google Sheets - Incorrect Decimal Format

  • May 21, 2023
  • 1 reply
  • 422 views
Blast Recording

This post was split from topic: 

It’s working, but I noticed the figure for the invoice is wrong by a couple of decimal points. Is there a way I can change this? 

 

£200 on an invoice is brought into Sheets as £20000

 

Thanks!

    This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

    1 reply

    ken.a
    Forum|alt.badge.img+6
    • ken.aZapier Staff
    • Zapier Staff
    • May 22, 2023

    Hi there @Blast Recording,

    I split your previous response into a new topic since the previous issue has been resolved, and it seems like you're encountering a different problem now. I hope you don't mind!

    It seems that you're experiencing an issue where numbers with decimals are not displaying correctly in Google Sheets, with commas and other formatting not appearing as expected.

    To fix this, you can follow these steps:

    1. Open your Google Sheets document.
    2. Navigate to the "File" menu at the top.
    3. Click on "Spreadsheet settings" in the dropdown menu.
    4. In the settings dialog box, select a locale that matches your desired formatting. For example, if you prefer the formatting used in European countries, you can choose a European locale. If you prefer the formatting used in the United States, select the corresponding locale.
    5. Click "Save" to apply the changes.

    By adjusting the spreadsheet settings to a matching locale, you should be able to resolve the issue and see the numbers with decimals displayed correctly, along with the appropriate formatting, such as commas.

    Hopefully, this helps! 😊

    Terms & ConditionsAccessibility statement