# How to replace a dot with a comma

**URL:** <https://community.homey.app/t/how-to-replace-a-dot-with-a-comma/64491>\
**Category:** Questions & Help\
**Created:** [June 8, 2022, 10:27am UTC](https://community.homey.app/t/how-to-replace-a-dot-with-a-comma/64491 "2022-06-08T10:27:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lars\_Machiels](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/lars_machiels/32/10295_2.png) [@Lars\_Machiels](https://community.homey.app/u/Lars_Machiels)\
**Post date:** [June 8, 2022, 10:27am UTC](https://community.homey.app/t/how-to-replace-a-dot-with-a-comma/64491/1 "2022-06-08T10:27:31Z")

</div>

I am trying to update a Google spreadsheet with some energy readings. I am using the app IFTTT and the card “Start applet with data”. The sheet is in EU format so I must use comma’s for decimal values. Is there any way I can format the data variables with comma’s instead of dots? Any help is  
 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/c/5c38cc3c9e905e45c1e52575b603f9f1c7cac26d.png)  
.

---

<div class="post-metadata">

**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\
**Post date:** [June 8, 2022, 3:50pm UTC](https://community.homey.app/t/how-to-replace-a-dot-with-a-comma/64491/2 "2022-06-08T15:50:35Z")

</div>

Hi, I don’t know how to convert the dots to comma’s. Maybe it can be done with Homeyscript…

But, this might be an idea:  
You can tell the spreadsheet a dot is a decimal sign. You have to change the language, to, like, English, and therefore set the country to Great Britain for instance:  
Go “File” and then “Settings”

 ![Screenshot from 2022-06-08 17-35-44](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/3/1300c2cc9e32fa623287a2f42330fa4f763220aa.png)

This way 10.256 is a valid value and the data import should go OK.

.  
When you have a NAS running or a server, you can use the [Archive Insights app](https://homey.app/a/com.gruijter.insights2csv/) to export those tags to .csv formatted files

---

<div class="post-metadata">

**Author:** ![Lars\_Machiels](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/lars_machiels/32/10295_2.png) [@Lars\_Machiels](https://community.homey.app/u/Lars_Machiels)\
**Post date:** [June 8, 2022, 6:23pm UTC](https://community.homey.app/t/how-to-replace-a-dot-with-a-comma/64491/3 "2022-06-08T18:23:57Z")

</div>

Thanks Peter. I already tried changing the sheet settings but then I have to change a zillion entries. So if I can just convert the dots to comma’s that would be better.

---

<div class="post-metadata">

**Author:** ![Erwin\_De\_Jong](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/erwin_de_jong/32/16500_2.png) [@Erwin\_De\_Jong](https://community.homey.app/u/Erwin_De_Jong)\
**Post date:** [January 20, 2023, 12:44pm UTC](https://community.homey.app/t/how-to-replace-a-dot-with-a-comma/64491/4 "2023-01-20T12:44:07Z")

</div>

i have the same question. would be nice that this would be a general option to define the default character for decimals.

the workaround seems to work for google sheets