format

[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

 

[Michael Bauer [MVP - Outlook]]

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:

 

[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]]

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:

 

[Sue Mosher [MVP]]

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.