cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pracmt1515
Frequent Visitor

Change coma to dot for decimal separator

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

 

pracmt1515_0-1627493126906.png

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")

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

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")

 

Best Regards,
Qi

View solution in original post

1 REPLY 1
v-qiaqi-msft
Community Support
Community Support

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")

 

Best Regards,
Qi

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,079)