|
| 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
May 15th 09, 05:19 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
format
Hi,
I looked for this but could not find it. I just need to format this to a currency value so that the value comes out to $4.00 instead of 4. Can someone please help. Item.UserProperties("12Percent").value Thank you so much, Joel 
|
| Ads |
|
#2
May 15th 09, 06:36 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
format
The Format function should help. Try: result= "$" & Format(Value, "#.##,##) -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 15 May 2009 09:19:43 -0700 schrieb Joel Allen: Hi, I looked for this but could not find it. I just need to format this to a currency value so that the value comes out to $4.00 instead of 4. Can someone please help. Item.UserProperties("12Percent").value Thank you so much, Joel
|
|
#3
May 16th 09, 12:11 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
format
Thanks, these dont' seem to work. Do you see anything wrong with it?
"Deposit of $" & Format(Item.UserProperties("12Percent").value,"#.# #,##) "Deposit of $" & Format(Item.UserProperties("12Percent").value,"#.# #,##") Thanks, Joel "Michael Bauer [MVP - Outlook]" wrote in message news  The Format function should help. Try: result= "$" & Format(Value, "#.##,##) -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 15 May 2009 09:19:43 -0700 schrieb Joel Allen: Hi, I looked for this but could not find it. I just need to format this to a currency value so that the value comes out to $4.00 instead of 4. Can someone please help. Item.UserProperties("12Percent").value Thank you so much, Joel
|
|
#4
May 16th 09, 12:03 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
format
What's the result or error message you get? -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 15 May 2009 16:11:54 -0700 schrieb Joel Allen: Thanks, these dont' seem to work. Do you see anything wrong with it? "Deposit of $" & Format(Item.UserProperties("12Percent").value,"#.# #,##) "Deposit of $" & Format(Item.UserProperties("12Percent").value,"#.# #,##") Thanks, Joel "Michael Bauer [MVP - Outlook]" wrote in message news The Format function should help. Try: result= "$" & Format(Value, "#.##,##) -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 15 May 2009 09:19:43 -0700 schrieb Joel Allen: Hi, I looked for this but could not find it. I just need to format this to a currency value so that the value comes out to $4.00 instead of 4. Can someone please help. Item.UserProperties("12Percent").value Thank you so much, Joel
|
|
#5
May 18th 09, 11:16 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
format
VBScript does not support the Format() function. Did you create 12Percent as
a currency field? If so, it should appear in the UI formatted as currency. Or are you looking to get $4.00 for use in some string in your code? In that case, you'll have to write your own function to add the dollar sign and trailing zeroes as needed. Or maybe a web site specializing in VBScript routines would have such a function readymade. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Joel Allen" wrote in message ... Hi, I looked for this but could not find it. I just need to format this to a currency value so that the value comes out to $4.00 instead of 4. Can someone please help. Item.UserProperties("12Percent").value Thank you so much, Joel
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I convert .pst format to .vcf format? | Lin xi | Outlook - Using Forms | 2 | December 9th 08 11:02 PM |
| Format of phone numbers automatically chaning format | leysy | Outlook - Using Contacts | 1 | April 29th 07 12:27 AM |
| Mail Merge - Format/Send Text and HTML Format | srm | Outlook - General Queries | 0 | January 17th 07 06:15 PM |
| How to change CONTACTS format on outlook 2003 to previous format | Changing format of all contact records | Outlook - Using Contacts | 3 | March 15th 06 10:51 PM |
| I need to save a contact in SMTP format not exchange format. | JAX | Outlook - Using Contacts | 0 | February 15th 06 01:51 PM |
Linear Mode
