Take a look he-

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"John" wrote in message
...
I have a column of numbers that I copy from an Internet Banking app. The
numbers are in General format when I paste them into Excel. Each "number"
is
in the format "#,###.##-" for withdrawls and "#,###.## " for deposits.

What I want to be able to do is find simple way to convert them to
positvie
and negative NUMBERS