Skip to main content
Nintex Community Menu Bar
Solved

Add an extra decimal to a currency value

  • June 26, 2025
  • 4 replies
  • 46 views

Forum|alt.badge.img+4

Hi everyone

I have a SharePoint column which is created as currency with two decimal places.

When I use this column in a Nintex Workflow Cloud workflow, the value returned only has one decimal place instead of two. 

How do I add another decimal to the number.

Example: “Cost” created as currency in SharePoint Online

The output of “Cost” should look something like R200.00, but in e-mails from Nintex the output from “Cost” is R200.0. How do I add the extra zero so that is displays with two decimal places?

Thanks

Best answer by SimonMuntz

After the convert to string action use a regular expression to replace the currency symbol. 

4 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+23
  • Nintex Employee
  • June 26, 2025

Hi ​@kirkie4567,

Have you tried using the Format number to string action before inserting the value into your email?
https://help.nintex.com/en-US/nwc/Content/Designer/Actions/FormatNumbertoString.htm


Forum|alt.badge.img+4
  • Author
  • Rookie
  • June 27, 2025

I did try that. But that action doesn't have the currency I want to use


SimonMuntz
Nintex Employee
Forum|alt.badge.img+23
  • Nintex Employee
  • Answer
  • June 27, 2025

After the convert to string action use a regular expression to replace the currency symbol. 


MillaZ
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • July 7, 2025

Hi ​@kirkie4567 
Have you solved your question?