format

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

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
 
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:
 
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
 
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.
 
Back
Top