I appreciate all the help. The PDF will be very useful in the future. Thanks,
Reese Reese E. Walker Financial Systems Analyst Phoebe Putney Memorial Hospital Phone: (229) 312-4259 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 3:42 PM To: [email protected] Subject: RE: [Talk] Formatting 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. ----------------------------------------- Disclaimer: The HIPAA Final Privacy Rule requires covered entities to safeguard certain Protected Health Information (PHI) related to a person's healthcare. Information being faxed to you may include PHI after appropriate authorization from the patient or under circumstances that do not require patient authorization. You, the recipient, are obligated to maintain PHI in a safe and secure manner. You may not re-disclose without additional patient consent or as required by law. Unauthorized re-disclosure or failure to safeguard PHI could subject you to penalties described in federal (HIPAA) and state law. If you the reader of this message are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, please notify us immediately and destroy the related message.
