I'm not savvy with Visual Basic either, It took a lot of Google time to get
some tips.
I also bought a Visual Basic for dummies book, it helps some, But not near
as much as the Webinars.
Thank you.
Clayton Leach
Integration Analyst
Phone 937-328-8104
FAX 937-328-6222
Information Systems
Community Mercy Health Partners
pbrungar
<[EMAIL PROTECTED]
.com> To
Sent by: "[email protected]"
[EMAIL PROTECTED] <[email protected]>
WORKSTATION.COM cc
Subject
12/05/2007 03:08 RE: [Talk] Formatting
PM
Please respond to
[EMAIL PROTECTED]
ATION.COM
Yeah....that's a whole cleaner than how I would have done it. :-)
Amount = "59999"
temp1 = Len(Amount)
Cents = Right(Amount, 2)
Dollars = Left(Amount, Temp1-2)
DollarsAndCents = Dollars & "." & Cents
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 2:05 PM
To: [email protected]
Subject: Re: [Talk] Formatting
FormatCurrency -Returns a string using a currency format
FormatCurrency(var1, 2)
Thank you.
Clayton Leach
Integration Analyst
Phone 937-328-8104
FAX 937-328-6222
Information Systems
Community Mercy Health Partners
"Walker, Reese"
<[EMAIL PROTECTED]
> To
Sent by: <[email protected]>
[EMAIL PROTECTED] cc
WORKSTATION.COM
Subject
[Talk] Formatting
12/05/2007 02:51
PM
Please respond to
[EMAIL PROTECTED]
ATION.COM
I am pulling a flat file into my data station and I need to format a money
field. I have a dollar amount of 59999 and I need it to be entered as
599.99. I do not know much VB so how would I code this?
Thanks,
Reese
Reese E. Walker
Financial Systems Analyst
Phoebe Putney Memorial Hospital
Albany, GA. 31702
Phone: (229) 312-4259
Pager: (229) 431-7658
Fax: (229) 312-4316
CONFIDENTIALITY NOTICE: This message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message.
Important: This email and any attachments may contain confidential
information subject to protection under the Federal Standards for Privacy
of Individually Identifiable Health Information (45 C.F.R. Parts 160 and
164). If you or your organization is a “Covered Entity” under the above
mentioned regulations, you are obligated to treat such information in a
manner consistent with the regulations. If it appears that this email was
sent to you in error, (1) you are prohibited from utilizing or
disseminating this email or any attachments; (2) please immediately delete
it from your computer and any servers or other locations where it might be
stored, and email this sender or call the Hays Medical Center Privacy
Officer at (785) 623-2188 advising that you have done so. We appreciate
your cooperation.
CONFIDENTIALITY NOTICE: This message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message.
