Skip to main content
Nintex Community Menu Bar
Solved

Add an extra decimal to a currency value

  • Jun 26, 2025 10:12 AM UTC
  • 4 replies
  • 110 views
  • Translate All

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 Simon Muntz

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

View original

4 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • Jun 26, 2025 10:36 PM UTC

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

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • Jun 27, 2025 9:16 AM UTC

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

Translate

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • Answer
  • Jun 27, 2025 9:23 AM UTC

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

Translate

MillaZ
Nintex Employee
Forum|alt.badge.img+23
  • Nintex Employee
  • Jul 7, 2025 11:42 AM UTC

Hi ​@kirkie4567 
Have you solved your question?

Translate