Answered

Excel numbers convert to different values if different browser language setting

(0) Share

Report

Posted on by dhhenrique

Hi,

I have an app that reads (only) some data from an excel file stored in a sharepoint site and one of the columns is a decimal number.

I've noticed that excel brings all the data as Text, and the problem is that when I try and convert the text to number using the Value() function it would give me a different result if the browser of the user is set up to English or Portuguese.

I've figured this behavior might be due to the different decimal separator used in each language. English uses "." (dot) and Portuguese uses "," (comma).But I can't figure how to solve it.

Has anyone dealt with this?

Note: I would not like to migrate this data in specific to a sharepoint list, I have some reasons to keep it in excel.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

victorcp 2,350 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

It happens because of the regional settings of the browser, if it is portuguese the decimal separator is comma if it is english the decimal separator is dot.

So if your data is in portuguese you can pass it as a parameter, like this:

Value("0,12", "pt-BR")

and it will understand that this number is in brazilian portuguese.

Any doubts let me know

Was this reply helpful? Yes No
dhhenrique on at

Like (1)

Report
Copy link

Link copied!

That worked, thanks. I had never really seen that optional second parameter.

Was this reply helpful? Yes No