Hi

type
-1
in an unused cell somewhere and copy it
then select all the numbers you need to convert and then choose
edit / paste special - MULTIPLY

Cheers
JulieD
PS do on a backup of your workbook first to ensure that you get the outcome
you want.


"godwingi" wrote in message
...
I have a very long list of positive numbers that I have converted from a
wordpad report. Actually it is our list of receivables. They have been
converted from text, and therefore the ones that should be credits, or
negative numbers (in context of receivables) appear as just plain positive
numbers, such as 150.00. I don't know of a simpler way to turn these
numbers
to negative (i.e. -150.00) without F2'ing each one and putting a minus (-)
sign in front of each one. It would save me so much time just to be able
to
change these numbers from positive to negative! If you could help me I
sure
would appreciate it!