PC Review
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Display result from Outlook formula.
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Display result from Outlook formula.
![]() |
Display result from Outlook formula. |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
How do I get the result of a formula calculation to display in rounded
numbers, not decimals. For example I have figured out how to use the FV foumula for future value and can plug in fields, but the result is a long number with four decimals and I would prefer to just see a result rounded to whole number. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
YOu can use the Round() function to round the result: Round(value, number_of_places)
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Elisabeth" <Elisabeth@discussions.microsoft.com> wrote in message news:909FDDBA-5FB9-4F51-BC63-323C81746119@microsoft.com... > How do I get the result of a formula calculation to display in rounded > numbers, not decimals. For example I have figured out how to use the FV > foumula for future value and can plug in fields, but the result is a long > number with four decimals and I would prefer to just see a result rounded to > whole number. |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

