A quick and dirty way would be this
Dim x
If InStr("99.99-", "-") > 0 Then
x = Mid("99.99-", 1, Len("99.99-") - 1)
x = x * -1
End If
John Burdek
Programmer Analyst
Saint Clare's Health System
66 Ford Road
Denville, NJ 07834
Phone: (973) 983-1532
Pager: (973) 259-2721
Fax: (973) 983-1530
[email protected] <mailto:[email protected]>
________________________________
From: [email protected] [mailto:[email protected]]
Sent: Thursday, March 19, 2009 11:18 AM
To: [email protected]
Subject: [talkbws] String Function
I am viewing a string on my screen and b/c STAR is stupid a
negative number shows up as 99.99-. Well excel doesn't like that, so I
need a function that will move the negative to the front of the number
if it is present. Can anyone help with this? I know how to replace a
character; I just don't know how to move it. I thought about just
viewing that last character separately and always putting it on front,
but it is left justified on the screen and I never know how many numbers
are going to be in front of it ahead of time. Any help is greatly
appreciated.
Thanks,
Reese
Reese E. Walker
Lead Financial Systems Analyst
Manager, Phoebe Cares Dept.
Phoebe Putney Memorial Hospital
Albany, GA. 31702
Phone: (229) 312-4259
Pager: (229) 431-7658
Fax: (229) 312-4316
________________________________
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.
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
DISCLAIMER: Saint Clare's Health System Confidentiality Notice: This e-mail
and any accompanying documents may be confidential and/or legally privileged.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance on
the contents of this information is strictly prohibited. If you have received
this e-mail in error, please notify the sender immediately by reply e-mail and
delete the message and any attachments. Thank you.
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
