One note of warning, formatting will make a number LOOK like a negative
number but the value held in the cell will still be positive.

Try entering 123, (it will show as -123 of course), in C1 then -1 in a cell
that has not been formatted - say D1. Now enter in D2 enter =C1*D1 you
will get -123 whereas if C1 had really been negative you would have had 123
returned.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Willing to learn" wrote in
message ...
It worked!

Thanks

" wrote:

You can try this:

Select C1:C20
Format Cells
Number
Custom--
-#,###,###.00

This should do it.


I would like to cells's C01:C20 do negatives numbers.
So that means that whenever I entered a number in those cells, my
numbers are going to be -