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 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!
Hi there
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:
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.