Thank you. Appreciate your formula. I also got a posting with this website,
http://www.mcgimpsey.com/excel/postfixnegatives.html. There is an Excel
feature called Text to Columns under the Data menu which easily accomplishes
this.


Dave O wrote:
One of the gurus will likely respond with a brilliant built-in Excel
function that does this automatically. Until they do, this work-around
will work. Assuming all your data is in column A, add a column, enter
this formula, and copy down to address the entire column of data:
=IF(RIGHT(TRIM(A1),1)="-",MID(TRIM(A1),1,LEN(TRIM(A1))-1)*-1,A1)

This formula checks each entry for the trailing negative sign, and
converts it from a string to a negative number; if the entry is
non-negative and numeric the formula returns the number. You can then
copy this column, paste it as values over your original data, and
delete the inserted column.


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