Chapter 14: Formatting Numbers

You might often find that numerical data values do not usually appear in the way you want them to be displayed visually or in the way your other apps will accept them. There might be several scenarios where this will be the case. For example, a lead may enter a contact phone number when they submit an inquiry form, but that format may not be recognized by your SMS app. Or, if your team submits timesheets, you may need to calculate their overtime payments before sending them a summary by email. You might also want to add a space, period, or comma to a number or transform a number into a specific currency format. As you can imagine, there are many possible situations when you might need to adjust a number, and that ...

Get Automate It with Zapier now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.