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