ENTER NEGATIVE AMOUNT

A

Anna

Hi there,

Is there a way to enter a positive number and it will show as a negative
number? Please advise.

Thanks,
 
G

Gary''s Student

Format > Cell... > Number > Custom and enter

"-"General

if you enter 5 in the cell it will display as -5
 
H

hot dogs

Would the -5 then shown be classed as a number or as text, could it be used
for calculations?
 
G

Gary''s Student

A good question.

The value in the cell is a number, not text. It could be used for
calculations. But remember that its true value is still 5, not -5

If A1 contained this value with this formatting, the cell would show -5 and
the formula bar would still show 5. If
=A1+100
were entered in another cell, it would show 105 as the result, not 95.
 
Top