|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
December 4th 07, 09:26 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Display result from Outlook formula.
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
December 4th 07, 02:13 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Display result from Outlook formula.
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" wrote in message ... 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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook Formula Help | Steve | Outlook - Using Forms | 1 | September 18th 07 06:24 PM |
| Outlook2003 finding delegate contacts will not display result? | Linda | Outlook - Using Contacts | 0 | August 20th 07 11:12 PM |
| Sum up all 'durations' in a Find result display | itambrose | Outlook - Calandaring | 4 | April 28th 07 04:32 PM |
| Outlook Script: How to get the result of an action | news.microsoft.com | Outlook and VBA | 4 | October 20th 06 01:18 PM |
| Custom Formula fields Outlook 2003 | Lee Halford | Outlook - Using Forms | 1 | February 4th 06 07:16 PM |
Hybrid Mode
