Number Formatter Workflow Action in Sparkforge

By Sparkforge Support Team ·Last reviewed May 3, 2026

The Number Formatter action covers five sub-actions: text-to-number, format number, format phone number, format currency, and generate a random number. Use it to clean inputs before later workflow steps.

The Number Formatter workflow action cleans up numeric data before later steps consume it. Five modes cover the common needs.

Text to Number

Convert a string like $12,345.67 into the number 12345.67.

Field	Description
Action Name	Custom label
Action Type	Text to Number
Select Field	The field with the text value
Input Decimal Mark	How decimals are marked in the input (e.g., period)

Example: on Form Submitted, convert a price string to a number for downstream payment logic.

Format Number

Apply decimal places and thousands separators to an existing numeric field.

Example: on a trigger link click, format a stat for display in an SMS.

Format Phone Number

Standardize phone numbers into formats like (123) 456-7890 or E.164. Pick the destination format and country.

Example: on Appointment Booked, format the contact's phone number into E.164 for outbound calling.

Format Currency

Apply locale-aware currency formatting.

Field	Description
Currency	USD, EUR, etc.
Currency Locale	Locale string (e.g., en-US)

Example: on Payment Received, format an amount for a receipt template.

Random Number

Generate a random number in a defined range.

Lower Range — minimum value (required)
Upper Range — maximum value (required)
Decimal Points — optional precision

Example: on Email Opened, generate a random number to split contacts into A/B test buckets.

Frequently Asked Questions

Can I strip currency symbols from a string before processing?

Yes. Use Text to Number and the action will parse values like $12,345.67 into a clean numeric value.

What phone formats are supported?

You can output common display formats like (123) 456-7890 or developer formats like E.164. Pick the country to handle prefixes correctly.

Does the random number support decimals?

Yes. Set the Decimal Points field to control precision. Leave it blank for whole numbers.

Where does Format Currency get the currency symbol?

From the Currency and Currency Locale you select. The locale also drives separators (commas vs periods) and symbol placement.

Can I chain Number Formatter with Math Operation?

Yes. Convert the input text to a number first, then pass it into a Math Operation action for any calculation.