One option once you've entered all the numbers as positive is to put -1 in a
spare cell, select and copy, the select your column, edit/ paste special/
multiply.

If you just want that column to display as if they were negative numbers,
you could format as "-"General, and then when you want to do calculations
from that column you could subtract instead of adding.
--
David Biddulph

"DeeDeeCee" wrote in message
...

I'm trying to add-subtract various numbers. One column will be nothing but
withdrawals from an account, so I want every number to be negative, so
that
if I do calculations with that column, they will always show as
deductions.
Is there a way I can set up the cells in that column so that any number I
type in will show as a negative number, ie. a -xx? I can simply type in a
hyphen before, I know, but I like to type fast without even thinking about
that extra and somewhat difficult (for me) key-stroke. Thanks.

dc