#1
|
|||
|
|||
Legacy Text Field with Calculation is Rounding
I'm using a legacy text field within a table to input a calculation that displays as 0.00%. The calculation works but it rounds. so if the answer should be 3.50% it rounds it to 4.00%. Is there a way to stop this from happening?
|
#2
|
||||
|
||||
What does the field code show when you toggle the field codes?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
{FORMTEXT {=(vert1-2)/2}}
vert 1 refers to another text box's input. |
#4
|
||||
|
||||
If you double click on the field, is there a Number Format set for it?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#5
|
|||
|
|||
There is.
0.00 And it spits out the calculation in that format, but the digits to the right of the decimal always show as zeros instead of the actual calculation. |
#6
|
||||
|
||||
I can't reproduce the issue on my machine - mine calculates correctly.
Perhaps attach your document to a post here so I can see what you actually have in your document.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#7
|
|||
|
|||
Here you go!
|
#8
|
||||
|
||||
I don't know what is going on with your form calculation field so just delete it and then replace it with a different field type.
Add a regular field in the last column by pressing Ctrl-F9. Then inside the {} which appear paste this text so it looks like { =(B2-2)/2 \# "0.000%" } Then lock the form and try again. In this formula, we are telling Word to use the value of Cell B2. So the Vertical acceptance formula will be almost the same but point at B3 instead.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#9
|
|||
|
|||
Thanks. I removed the legacy text field and just used your field code in the table cell. That seemed to do the trick!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unsure why running a macro that generates text is deleting the legacy form field I want the text in | Rakyn87 | Word VBA | 1 | 03-18-2019 02:12 PM |
Rounding a merge calculation to whole number | finners01 | Mail Merge | 1 | 12-03-2018 04:55 AM |
Currency Field not showing $ and is rounding | Juliesctt | Mail Merge | 3 | 07-05-2016 06:43 PM |
VBA Code to Insert Legacy Text Field | PSSMargaret | Word VBA | 17 | 06-15-2016 04:22 AM |
Grammar check into legacy forms > Text form field. | Eduardo Care | Word | 2 | 09-09-2015 03:11 PM |