You’re offline. This is a read only version of the page.
Announcements
36
Hello there!
I have a drop down menu, with this items 0, 0,5, 1, 1,5, 2...
When the form is sent to excel the numbers are sent in a text format not in a numeric format.
This happen only with decimal numbers.
Example: 2 is sent correctly, 2,5 is sent in a text format and i can't find a way to convert the values.
Thank you in advance for your help!
It seems the language locale setting is different between Power App and Excel.
Outside continental Europe, the decimal numbers are written with a dot instead of comma. So you would see 2.5 instead of 2,5
Excel is reading in locale setting outside continental Europe and hence 2,5 is being read as a text -- i.e., two numbers (2 and 5) separated by a comma.
Ideal solution
1 - Check and ensure language locale setting is same across all Excel, Power App etc..
Alternate solution
2 - Replace comma by dot
Share
Report
All responses (
Answers (
Value(Replace(Dropdown.Selected.Value, ",", "."))
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.
