Thank you. My colleague has been struggling with this for years, tediously
fixing each instance. I was sure one of you smart people could help.

JE McGimpsey wrote:
take a look he

http://www.mcgimpsey.com/excel/postfixnegatives.html

We receive data from an outside source and have no control over its
appearance. On their worksheet negative numbers show up like this $4.33- or
8-. I can use a wildcard character in the search field to find these
occurences but have found that I can't change the format to the proper one, -
$4.33 or -8. In the search field I enter *- but if I enter -* in the replace
field, Excel replaces my number with -*. Suggestions?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1