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,4…

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

Data type

Marcel_Ubels January 19, 2023, 9:30am 2

This Link could be of some help.

Topic		Replies	Views
Homewizard P1 meter data is displayed incorrectly in Google spreadsheet Flows	5	67	July 11, 2026
Neue App Google Sheets Apps (DE)	22	1462	February 5, 2023
Meterstanden wegschrijven naar Google sheets 🇳🇱 Nederlands (Dutch) app , p1 , advancedflow	12	587	March 1, 2025
How to replace a dot with a comma Questions & Help	3	904	January 20, 2023
Google sheets punt vervangen door komma in getallen Off-Topic not-a-homey-problem	3	637	April 24, 2026