If you just want them formatted as negative, use a format of

-General;-General

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Winfield" wrote in message
...
I am creating a spreadsheet that has a group of cells that is always a
negative number. I would like any number entered to default to negative
in
case the negative sign is forgotten when the number is entered. Can a
group
of cells be formated so they always appear as a negative nember? I am
using
Excel 2003.