Skip to main content
Nintex Community Menu Bar
Solved

Convert Number Value to Text String That Always has Two Decimal Places

  • May 14, 2026
  • 2 replies
  • 16 views

bamaeric
Nintex Partner
Forum|alt.badge.img+14

On a Nintex Workflow online form, I have a Number control configured as Numeric Type of Decimal and Number of Decimal Places as 2. I set the value of the Text control with what is in the Number control via a rule. I need the string in the Text control is always have two decimal places.

The issue is the Text string does not always show two decimal places. Below is what actually displays versus what I need to display in the Text control.

Value in Number Control Currently Displays in Text Control Needed to Display in Text Control
123.00 123 123.00
123.40 123.4 123.40
123.45 123.45 123.45

 

 

Best answer by brent_read

Hey Eric,

 

May not be the cleanest method but you could do something like this: replace(convertToString([Form].[Number 1] + .001),"[0-9]$","")

Essentially forces the decimal to have 3 trailing digits then removes the last digit.

2 replies

Forum|alt.badge.img+11
  • Nintex Employee
  • Answer
  • May 14, 2026

Hey Eric,

 

May not be the cleanest method but you could do something like this: replace(convertToString([Form].[Number 1] + .001),"[0-9]$","")

Essentially forces the decimal to have 3 trailing digits then removes the last digit.


bamaeric
Nintex Partner
Forum|alt.badge.img+14
  • Author
  • Nintex Partner
  • May 14, 2026

Thanks ​@brent_read . This worked for what I needed to do.