You could format the column to look like negative numbers but the numbers
would still be positive. Much better to enter them as positive and then
change them by entering -1 in an empty cell, copying it, highlighting the
column and the selecting Paste Special Multiply


--
HTH

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


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


"MS" wrote in message
...
Is it possible to highlight and format a part of a column before entering
data so that whatever entered is a negative number? This way i do not
have
to press the minus sign before entering the number.

Thank u
ms