Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Format as Currency

Steel Contributor

hello experts,

 

I need to format [Amount] as either $, €, or kr

 

I have a field [Currency] that is text and displays one of 3 currencies: USD, EUR or DKK

How can I display the currency symbol in my [Amount] field based on the text value in [Currency]? 

$12,345.45

€12,345.45

kr12,345.45

thank you 

2 Replies
best response confirmed by Tony2021 (Steel Contributor)
Solution
your system only assign 1 currency symbol based on your regional setting.
for multiple currency, you need an additional short text field to put those
different currency symbol.
I just covered this in one of my videos. See: https://599cd.com/CurrencySymbols
1 best response

Accepted Solutions
best response confirmed by Tony2021 (Steel Contributor)
Solution
your system only assign 1 currency symbol based on your regional setting.
for multiple currency, you need an additional short text field to put those
different currency symbol.

View solution in original post