Text Language set "$", but actual display "￥"

(0) Share

Report

Posted on by LoongWang

Set "Text(ThisItem.Price,"[$-en-US]$#,###.00")" in Power Apps Studio, but display with "￥1,899.99"

Categories:

Using Apps Using Formulas

Text Issue.png

All responses (7)

Answers (0)

LoongWang on at

Like (0)

Report

Re: Text Language set "$", but actual display "￥"

The issue is also seen when using Text(1234.56,"[$-en-US]$#,###.00")" in Apps
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Text Language set "$", but actual display "￥"

Hi @LoongWang,

Could you please share more details, like number settings for the Price column in your excel table?

Here is how I set the Number column in my excel table.

In addition, I suggest you create a general column instead to save the format currency.
LoongWang on at

Like (0)

Report

Re: Text Language set "$", but actual display "￥"

The Price in Excel

Price.png
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Text Language set "$", but actual display "￥"

Hi @LoongWang,

Go and check your column settings. The following is my Number column settings, please check as below:

I have a test and the situation is confirmed on my side:

Note that the PriceR is a Number column in my SP list.
LoongWang on at

Like (0)

Report

Re: Text Language set "$", but actual display "￥"

Number
v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Text Language set "$", but actual display "￥"

Hi @LoongWang,

Could you please tell me if the Price column is a Number or Text type?

If it is a Text type, please modify your formula as below:

Text(Value(ThisItem.Price),"[$-en-US]$#,###.00")
logixcrm 71 on at

Like (0)

Report

Re: Text Language set "$", but actual display "￥"

It may be a long shot, but check your currency settings under Advanced Settings > Settings > Administration > System Settings.