These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Formatting Text Field

Forum Index > Forms: Acrobat > Formatting Text Field
2010-11-03 10:03:08
lab63
Registered: Nov 3 2010
Posts: 5
Answered

I am using Adobe Acrobat 9 Pro Version 9.4.0. I have created a field to calculate a currency amount. I want the resulting amount to not have a decimal appear. I have tried setting the formatting to number then currency, but the options for separator style only show styles with a decimal showing. I have also selected none for formatting but the result calculation still show a decimal. For example: I want the amount of $1.20 to appear as 120. Does anyone know how I can get it to format like this?

My Product Information:
Acrobat Pro, Windows
Top
2010-11-03 10:29:45
#1
try67
Expert
Registered: Oct 30 2008
Posts: 2399
Set it as Number with 0 decimals and multiple by 100.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top
2010-11-03 10:46:47
#2
lab63
Registered: Nov 3 2010
Posts: 5
Thank you. That worked for that particular field but it causes another problem. I will explain further what I'm trying to achieve. The calulated amount is part of a subtotal. When I change the muliple to 100 as you suggested, my subtotal is returning the amount of $120.00 rather than $1.20. The total amount is doing the same. Any other suggestions?
Top
2010-11-03 10:50:52
#3
try67
Expert
Registered: Oct 30 2008
Posts: 2399
You need to divide it by 100 when calculating the total.
If you used the built-in sum function, you will need to use something else, like the Simple Notation field.
You enter into it a simple formula using the fields' names, like so (let's say field3 is that one in question):
field1 + field2 + (field3/100) + field4

Be aware that the fields' names can contain spaces or other special characters for this to work.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top
2010-11-03 11:19:58
#4
lab63
Registered: Nov 3 2010
Posts: 5
OK. The formula works and the correct amount is now (almost) showing, but there are still problems. When I'm not in the field all that shows is the number 1, when I tab to the field it shows 1.2 (not 120 and a decimal appears). Sorry to be a pain.
Top