# Google sheets punt vervangen door komma in getallen

**URL:** <https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121>\
**Category:** Off-Topic\
**Tags:** not-a-homey-problem\
**Created:** [August 28, 2024, 10:43am UTC](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121 "2024-08-28T10:43:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Piet\_Bax](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/piet_bax/32/41150_2.png) [@Piet\_Bax](https://community.homey.app/u/Piet_Bax)\
**Post date:** [August 28, 2024, 10:43am UTC](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121/1 "2024-08-28T10:43:40Z")

</div>

Ik stuur via de Google Sheets app, waarden naar een Spreadsheet. Jammer genoeg worden gebroken getallen door de Spreadsheet gezien als tekst. bijv. 23.80. Dit zou 23,80 moeten zijn.  
Weet iemand een manier om dit op te lossen?

---

<div class="post-metadata">

**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\
**Post date:** [August 28, 2024, 10:47am UTC](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121/2 "2024-08-28T10:47:01Z")

</div>

> [@\[APP\] Google Sheets - Append to Google Sheets from a Flow](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/12):
>
> I’ve set the Country setting for the sheet to “United States”, so it accepts a period as decimal separator: [image]

---

<div class="post-metadata">

**Author:** ![JohanP](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johanp/32/119002_2.png) [@JohanP](https://community.homey.app/u/JohanP)\
**Post date:** [November 1, 2024, 10:44am UTC](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121/3 "2024-11-01T10:44:19Z")

</div>

heb hier ook mee lopen klieren, afgezien van de ‘United States’ setting :

selecteer de betreffende kolom, rij of cellen,  
dan kies : meer indelingen :

![afbeelding](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/6/f6cc8b81818a77a3cfb06b000f3137916d4f9db4.png)

Dan aangepaste getalnotatie :

 ![afbeelding](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/f/cf9108ae7176082d3acd4a8f81b61c69cb6b53bb.png)

selecteer deze :

 ![afbeelding](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/f/0ffc9795f32c810f03f24b42f10bd349294211ed.png)

---

<div class="post-metadata">

**Author:** ![Jeroen\_Spruijt](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jeroen_spruijt/32/7917_2.png) [@Jeroen\_Spruijt](https://community.homey.app/u/Jeroen_Spruijt)\
**Post date:** [April 24, 2026, 8:14pm UTC](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121/4 "2026-04-24T20:14:13Z")

</div>

Je zou eventueel ook kunnen scripten met apps script, zo heb ik het in iedergeval opgelost