Unanswered

Format "1000.55" into "$1,000.55" in Power Automate Desktop

(2) Share

Report

Posted on by Zy_Sin

Hi
anyone know how to change 1000.55 into $1,000.55 in Power Automate Desktop?
i have uses action text to number but the end result still shows 1000.55

my variable say is SPNo = 1000.55 which is a text

i uses convert text to number with new variable as intSPNo
when i display it as $%intSPNo%

it shows $1000.55

i need the thousand separator to be shown

Pls help

Thanks

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

Sayan 818 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @Zy_Sin

You can use the following approach to convert 1000.55 to $1,000.55

Copy and Paste the Code in your workflow :

SET Number TO 1000.55
SET formattedNumber TO 0
@@copilotGeneratedAction: 'False'
Scripting.RunPowershellScript.RunPowershellScript Script: $'''$number = %Number%
$formattedNumber = \"{0:N2}\" -f $number
return $formattedNumber
''' ScriptOutput=> PowershellOutput
SET NewVar TO $'''$%PowershellOutput%'''

Main Work Flow :
Output :

PowerShell Script:

PowerShell Code :
$number = %Number%
$formattedNumber = "{0:N2}" -f $number
return $formattedNumber

------------------------------------------------------------------------------------------------------------------------------
If my suggestion helped you, please give it a Thumbs up 👍 and Mark it as a Solution 🤖 so that it can benefit others in the community.
Sayan Patra
RPA Developer
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Zy_Sin ,

Please find the solution.There are 2 methods you can achieve this.

Method 1: The simplest way is to not to convert Text to number.

Code:

SET intSPNo TO $'''1,000.50''' SET Currency TO $'''$%intSPNo%''' Display.ShowMessageDialog.ShowMessage Message: Currency Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed14

Method 2: Using some script.

Code:
SET intSPNo TO $'''1,000.50''' Text.ToNumber Text: intSPNo Number=> intSPNo @@copilotGeneratedAction: 'True' Scripting.RunVBScript.RunVBScript VBScriptCode: $'''Function FormatCurrency(value) \' Format the value as currency with dollar sign and commas Dim formattedValue formattedValue = FormatNumber(value, 2) formattedValue = \"$\" & formattedValue FormatCurrency = formattedValue End Function \' Example usage Dim value value = %intSPNo% Dim result result = FormatCurrency(value) WScript.Echo result''' ScriptOutput=> Convert ScriptError=> ScriptError6

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy
Riyaz_riz11 4,219 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
HI @Zy_Sin

Refer this:

SET inputVariable TO 1000.55 Text.ToNumber Text: inputVariable Number=> inputVariable @@copilotGeneratedAction: 'True' Scripting.RunVBScript.RunVBScript VBScriptCode: $'''Function FormatCurrency(value) Dim formattedValue formattedValue = FormatNumber(value, 2) formattedValue = \"$\" & formattedValue FormatCurrency = formattedValue End Function Dim value value = %inputVariable% Dim result result = FormatCurrency(value) WScript.Echo result''' ScriptOutput=> strConvertedAmount

Copy and paste the code in PAD.

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

Regards,
Riyaz