About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

  • 22 May 2023
  • 1 reply
  • 135 views
Blast Recording
Userlevel 1

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!

1 reply

ken.a
Userlevel 7
Badge +6

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! 😊

Reply


Terms & Conditions