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
