Try this, hilight all the cells or column you want this for, right click,

'Format cells'----'custom' in the box where it says 'type' type in -######

"BW" wrote:

I have a worksheet that has several cells that when data is entered will
always need to be negative. How can I enter the number without having to put
the minus sign in and have it come out as a negative.
--
B