How to Convert Currency Amounts to Words in Acrobat PDF Forms
Question details
The user wants to automatically convert numeric dollar amounts into English words with fractional cents in a fillable PDF form.
- Product
- Adobe Acrobat / PDF Forms
- Device & OS
- not provided
- Scenario
- Creating a fillable PDF form that requires a written-out currency total, such as for invoices or digital checks.
- Observed behavior
- The user needs a script to read a numeric total and output the formatted text because Acrobat lacks a native currency-to-words function.
Ensure you have access to a PDF editor that supports adding and testing custom JavaScript calculations in form fields, such as Adobe Acrobat Pro.
Add a Custom JavaScript Calculation to the PDF Form Field
Use a custom JavaScript snippet in the destination text field to read the numeric total, separate the dollars and cents, and convert it into words.
Since PDF editing software does not have a built-in function to translate numbers into English words, you must write a custom JavaScript function. This script splits the decimal value and uses an array to map digits to their corresponding English words.
Open your fillable PDF in your PDF editor (like Adobe Acrobat) and enter the 'Prepare Form' mode from the tools menu.
Right-click the destination text field where you want the converted words to appear and select 'Properties'.
In the Text Field Properties window, click on the 'Calculate' tab and select the 'Custom calculation script' option.
Click the 'Edit' button and paste your custom JavaScript. The script should extract the value from the numeric total field using `this.getField('TotalField').value`, convert the whole number into words, append the cents as XX/100, and assign the final string to `event.value`.
Click 'OK' to save the script and close the Properties window. Exit form editing mode and type a number into the source field to verify the conversion works correctly (e.g., 456.26 becomes 'Four hundred fifty-six and 26/100').
Edit and Fill PDF Forms smoothly with WPS Office
WPS Office provides a comprehensive suite of PDF tools allowing you to easily read, fill, edit, and manage interactive PDF forms without needing heavy or expensive software.
- 1. Open WPS Office: Launch WPS Office on your device and click on the 'PDF' tab on the home screen.
- 2. Open Your PDF Form: Select 'Open' and browse your computer to load your fillable PDF document.
- 3. Fill and Edit: Click on the interactive form fields to enter your data. If the form lacks interactive fields, use the 'Fill & Sign' tools to insert custom text boxes.
- 4. Save Your Document: Go to Menu > Save As to export the completed PDF form to your local drive or cloud storage.
Frequently Asked Questions
Why doesn't Acrobat convert numbers to words automatically?
PDF editing software like Acrobat focuses on document structure and basic mathematical calculations (sum, product, average). Converting numbers to natural language strings requires complex parsing rules that vary heavily by language, which must be handled by custom JavaScript.
Can I use this JavaScript in any PDF reader?
The script will work in most advanced PDF viewers that support JavaScript calculations. However, some basic mobile PDF readers or built-in web browsers may block PDF JavaScript execution for security reasons.
How do I handle amounts larger than thousands in the script?
Your custom JavaScript needs to be robust enough to handle arrays for 'thousands', 'millions', and 'billions'. You will need to implement a loop or recursive function within the script to parse larger number blocks accurately.
What if my cents portion is exactly zero?
You can write a conditional statement (if/else) in your JavaScript to check if the decimal portion is exactly .00. If it is, the script can be programmed to output '00/100' or omit the cents portion entirely based on your specific formatting preference.
