# How to pass numbers to google sheets with comma instead of dot

**URL:** <https://community.n8n.io/t/how-to-pass-numbers-to-google-sheets-with-comma-instead-of-dot/19722>\
**Category:** Questions\
**Tags:** google-sheets, webhook\
**Created:** [November 14, 2022, 11:57am UTC](https://community.n8n.io/t/how-to-pass-numbers-to-google-sheets-with-comma-instead-of-dot/19722 "2022-11-14T11:57:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Linecker](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/linecker/32/15441_2.png) [@Linecker](https://community.n8n.io/u/Linecker)\
**Post date:** [November 14, 2022, 11:57am UTC](https://community.n8n.io/t/how-to-pass-numbers-to-google-sheets-with-comma-instead-of-dot/19722/1 "2022-11-14T11:57:28Z")

</div>

## Problem With Dot instead Comma

Hello, I would like the numbers passed to google sheets to come configured to come with a comma, instead of a dot. I already tried using loLocaleString in Set Node and also User Entered to Value Input Mode on Google sheets node. But nothing is working. All numbers are coming with a comma instead of a period. For example:

453.32 instead of 453,32

As in Brazil we use a comma to determine the decimal places, google sheets can’t understand the values are weird. He can’t add the value.

When values come with a comma, google sheets automatically understands that it is a currency value and puts the brazilian real sign.

Like This:

R$ 453,32

Can someone help me, please?

## Worflow

## n8n setup

- **0.202.1**
- **Google Sheets**
- **Running n8n with the execution process [own(default), main]:**
- **Docker**

---

<div class="post-metadata">

**Author:** ![BramKn](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/bramkn/32/11894_2.png) [@BramKn](https://community.n8n.io/u/BramKn)\
**Post date:** [November 14, 2022, 4:17pm UTC](https://community.n8n.io/t/how-to-pass-numbers-to-google-sheets-with-comma-instead-of-dot/19722/2 "2022-11-14T16:17:27Z")

</div>

I would simply use a .replace(‘.’,‘,’) I guess

---

<div class="post-metadata">

**Author:** ![Linecker](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/linecker/32/15441_2.png) [@Linecker](https://community.n8n.io/u/Linecker)\
**Post date:** [November 20, 2022, 6:25pm UTC](https://community.n8n.io/t/how-to-pass-numbers-to-google-sheets-with-comma-instead-of-dot/19722/3 "2022-11-20T18:25:44Z")

</div>

Unfortunately I already tried to do that, this ends up being a problem in the near future