# Data type

**URL:** <https://community.homey.app/t/data-type/75305>\
**Category:** Questions & Help\
**Created:** [January 19, 2023, 9:03am UTC](https://community.homey.app/t/data-type/75305 "2023-01-19T09:03:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Japper](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/japper/32/18032_2.png) [@Japper](https://community.homey.app/u/Japper)\
**Post date:** [January 19, 2023, 9:03am UTC](https://community.homey.app/t/data-type/75305/1 "2023-01-19T09:03:59Z")

</div>

Hi everyone,  
Since this week I’m using the Google Spreadsheet app to log the energy consumption on an hourly basis. However, when I open the result in Google Spreadsheets, the result is shown as text, because it looks like this; _123.45_. Google sees this as a text, since the expected format is _123,45_ (a comma instead of a dot). Is there a way to change the data output from Homey to Google Spreadsheets? The data is coming from the HomeWizard P1 meter (HomeWizard app).  
Thanks!

---

<div class="post-metadata">

**Author:** ![Marcel\_Ubels](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marcel_ubels/32/18860_2.png) [@Marcel\_Ubels](https://community.homey.app/u/Marcel_Ubels)\
**Post date:** [January 19, 2023, 9:30am UTC](https://community.homey.app/t/data-type/75305/2 "2023-01-19T09:30:30Z")

</div>

This [Link](https://community.homey.app/t/how-can-i-save-a-tag-as-an-integer-instead-of-a-float/75262) could be of some help.

---

<div class="post-metadata">

**Author:** ![Robin\_De\_Lange](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robin_de_lange/32/25173_2.png) [@Robin\_De\_Lange](https://community.homey.app/u/Robin_De_Lange)\
**Post date:** [January 19, 2023, 10:29am UTC](https://community.homey.app/t/data-type/75305/3 "2023-01-19T10:29:24Z")

</div>

you have to set the language of Sheets to English or US. Then you will see it as data not a tekst, you can change this in the settings of Sheets
