Change coma to dot for decimal separator

Like (0) Share

Report

Posted on 28 Jul 2021 17:27:13 by pracmt1515

I have conceted an excel file to the Power APP database, In the app the people can put the duration of each operation, the problem is that sometimes when the poeple put de duration the excel file dosent recognize the decimal separator and instead of for example putting 0.33 puts it 3333333333

This is how the people puts the Duration

and this is the formula i have

Value(Round(('Fecha Fin_DataCard5_19'.Update - 'Fecha Inicio_DataCard6_19'.Update)*24;2);"es-ES")

Categories:

General Questions

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on 29 Jul 2021 at 03:15:17

Like (0)

Report
Re: Change coma to dot for decimal separator

Hi @pracmt1515,

Based on the issue that you mentioned, do you want to format the duration using a dot?

Could you please share a bit more about your scenario?

Actually, the decimal separator in your region is indeed a comma rather than a dot. If you want to change it, you could use the Substitute function to replace ',' to '.'.

Substitute(Text(Value(Round(('Fecha Fin_DataCard5_19'.Update - 'Fecha Inicio_DataCard6_19'.Update)*24;2);"es-ES"));",";".")

Or you could use the Text() function.

Text(Value(Round(('Fecha Fin_DataCard5_19'.Update - 'Fecha Inicio_DataCard6_19'.Update)*24;2);"es-ES");"[$-en-US]##.#";"en-US")