When working with partners and external systems, it’s common to receive data that doesn’t quite match the format you require. The Format numbers step transforms values into whatever custom numeric value you require. 

Building challenge

• Add a card titled “Format currency values” after our “Format date values” card and drop a Format numbers step on the card.
• Update the format of the Line Item Price column to include a dollar sign ($) and two decimal places. 

To check your work, take a look at this quick video.

How to use the step

1. Drag a Format numbers step onto the canvas. 
2. Select the columns you want to reformat. 
3. Specify an updated format for the column values. 
4. Click the three dots next to your format selection to access advanced settings such as number of decimal places, currency symbols, and rounding options. 

Pro tip

• Unlike traditional spreadsheets that require data types to be specified per column, Parabola handles this automatically.
• If you ever run into an Invalid Format issue while using an Add math column step (which we’ll go over in the next lesson), use the Format numbers step before the calculation to ensure the data is properly formatted.

Visit our support docs to learn more about the step.