Yes, and if you want it all in one line then
=IF(RIGHT(TRIM(cname),1)="-",-1 *
VALUE(REPLACE(cname,FIND("-",cname,1),1,"")),VALUE(cname))
*A1 is your column name
From: [email protected] [mailto:[email protected]]
Sent: Thursday, March 19, 2009 10:55 AM
To: [email protected]
Subject: [talkbws] RE: String Function
Greetings,
All look valid to meJ Isn't there a song "There must be 50 ways to move a
negative?"
I'd use:
data = "99.00-"
If InStr(data, "-") Then
data = "-" & StrReplace(data, "-", "")
End If
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
HIMSS Booth 3445
Sign <http://www.bostonworkstation.com/customer_center/special_events.aspx>
up for my weekly webinar!
LEGAL NOTICE Unless expressly stated otherwise, this message is confidential
and may be privileged. It is intended for the addressee(s) only. Access to
this E-mail by anyone else is unauthorized. If you are not an addressee, any
disclosure or copying of the contents of this E-mail or any action taken (or
not taken) in reliance on it is unauthorized and may be unlawful. If you are
not an addressee, please inform the sender immediately, then delete this
message and empty from your trash.
From: [email protected] [mailto:[email protected]]
Sent: Thursday, March 19, 2009 11:18
To: Talk
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.asp
x
---
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.asp
x
---
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
