I had a calc field that calculated amount of days from the current date to the entered in another date field (Date_Grad). Recently, I had to change the calc to figure to reflect months instead of days:

(Date_Grad - Status(CurrentDate)) / 30 result is a Number

The field was reflecting an extensive decimal value. For example, 71.366667. So I went to Format/Number and set the fixed number of decimal digits to zero. This seemed to fix the problem, but I also have a merge field on another layout, but it still says 71.366667. How can I change this merge field to eliminate the decimal digits?

Thanks

Ken

You do it the same way that you did on the other layout.

Is there some reason that this will not work?

Field Format only affects the way the field is displayed, not what its actual contents are. So you would need to apply the same Field Formatting to each visible field.

You could also actually modify the contents of the field itself with the Round function. That way it will show up the same way in any field.

Thanks for the replies, guys.

Ok, I see. I screwed up. Prior to posting, I went to the other layout and did Format/Number, but I did not select the body of text that the merge field was in. I think thats why it didn't work. After I saw your guys' post, I went back and right-clicked/Format/Number, adjusted the decimal digit and it worked.

Thanks for helping out.

Ken