format

  • Thread starter Thread starter Joel Allen
  • Start date Start date
Status
Not open for further replies.
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

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
 
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 " <mb@mvps.org> wrote in message

news:pxb0exu6p3e6.v6sdvmq1my88.dlg@40tude.net...

> The Format function should help. Try:
> result= "$" & Format(Value, "#.##,##)

> > Best regards
> Michael Bauer

> >

> 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
 
What's the result or error message you get?

Best regards

Michael Bauer

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 " <mb@mvps.org> wrote in message
> news:pxb0exu6p3e6.v6sdvmq1my88.dlg@40tude.net...
>

>
>> The Format function should help. Try:
> > result= "$" & Format(Value, "#.##,##)
>

>> > > Best regards
> > Michael Bauer
>

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

"Joel Allen" <joelallen123@hotmail.com> wrote in message

news:eyLcAkX1JHA.1644@TK2MSFTNGP02.phx.gbl...
> 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
>
 
Status
Not open for further replies.
< Daily hours of recurring/ multi-day appts, & accessing mult calend | newsgroup FAQ and website >
Similar threads
Thread starter Title Forum Replies Date
J unable to get my new install of Outlook to display mailboxes in the single-line format. Using Outlook 1
e_a_g_l_e_p_i MY Outlook 2021 changed the format of the shortcuts for mail, calendar etc. Using Outlook 10
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
R How to prevent corrupted Notes format in Calendar and Contacts Using Outlook 0
S Combination Field (Date Format) Outlook VBA and Custom Forms 0
L Format Lost between Tasks and To Do Using Outlook 0
P Outlook 2016 Change Paste Special Default Format Using Outlook 8
S Format Inbox Using Outlook 0
P Short Date Format when typing in a task Using Outlook 2
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
K Need to convert .mmf file to .pst format Outlook VBA and Custom Forms 7
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
C Export NSF Lotus Notes files in Outlook PST format? Using Outlook 1
L Time format in Outlook calendar and emails Using Outlook 0
Y Outlook Task View - Table Format - Customize Reminder Time to Drop-Down Selection Using Outlook 2
T How to Export mailbox from Outlook 2019 to MBOX format? Using Outlook 1
J What is the best EntryID format to set on MS Access table Outlook VBA and Custom Forms 3
e_a_g_l_e_p_i Is there a way to add something that is in the "Format Text" tab to the "basic Text" on the message tab Using Outlook 1
E Outlook 2010 Can somebody tell me , the question associated with OST format Using Outlook 1
Witzker Correct Format of custom Yes/No Checkboxes Outlook VBA and Custom Forms 0
M font format discrepancies with Quick Parts Using Outlook 1
S Email Format With Embedded Images and Tables Change Using Outlook 2
G How to filter by the format of an email address Using Outlook 6
T Format Reading Pane Outlook VBA and Custom Forms 5
R Lost PST files after format Using Outlook 6
J Outlook 2013 how to convert 2013 OST file into an another format, i m using outlook 2013 versions. Using Outlook 1
fitzgerald Lost PST files after format - how to recover deleted files? Using Outlook 3
Dr. Demento Outlook output to array -> Excel & re-format Using Outlook 2
P Outlook 2010: Missing tab - "Format/Picture Tools" HELP! Using Outlook 3
skylark53 Loss of default format on deleting signature Using Outlook 5
O Setting default format for composing/replying to emails Using Outlook 3
divan VbaProject: Changing email format Using Outlook 15
O VBA to change message format and add formatted signature Outlook VBA and Custom Forms 1
divan Macro to format email in a certain folder then forward to email address Using Outlook 3
M Macro to Format certain words in email message Outlook VBA and Custom Forms 5
J Format change when dragging from email to Task Using Outlook 1
P Outlook 2013 Phone Number Format Using Outlook 0
R How to format text within appointment/meeting body? Using Outlook 6
L Excel table format lost in Outlook Using Outlook 6
M Email Format getting changed to Plain Text Using Outlook 1
H Disaster. Management wants to change email format. Exchange Server Administration 9
G Outlook 2013: Getting meeting invites in OWA format Using Outlook 9
S Change answer format Using Outlook 1
R printing custom number of calendar days in weekly view format Using Outlook 1
D outlook 2010 table format lost on send Using Outlook 1
M Save embedded image in native format Using Outlook 6
P Template format not preserved Using Outlook 3
R NUMBER Format Using Outlook 0
M Mail in HTML format can't be sent if url or number is in the body Outlook 2010 Using Outlook 2
B Changing Calendar format Using Outlook 1

Similar threads

Back
Top