Inputting Negative Numbers in spreadsheet

  • Thread starter Thread starter Jan Brown
  • Start date Start date
J

Jan Brown

A lot of my data entry requires that numbers be entered as
negatives. Custom formatting a cell as a negative doesn't
work. I still have to hit the minus key to render the
number negative. I don't want to have to use the minus key
each time. Thanks!
 
<A lot of my data>: That' s the problem.

But if the dat is in a contiguous range, use the following.

In an empty cell, enter the number -1. Edit>Copy.

Select the data you require to be negative.
Edit>Paste Special, check Multiply.
--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top