ENTER NEGATIVE AMOUNT
 

Hi there,

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

Thanks,

ENTER NEGATIVE AMOUNT
 

Format Cell... Number Custom and enter

"-"General

if you enter 5 in the cell it will display as -5
--
Gary's Student


"Anna" wrote:

Hi there,

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

Thanks,

ENTER NEGATIVE AMOUNT
 

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

"Gary''s Student" wrote:

Format Cell... Number Custom and enter

"-"General

if you enter 5 in the cell it will display as -5
--
Gary's Student


"Anna" wrote:

Hi there,

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

Thanks,

ENTER NEGATIVE AMOUNT
 

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.
--
Gary''s Student


"hot dogs" wrote:

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

"Gary''s Student" wrote:

Format Cell... Number Custom and enter

"-"General

if you enter 5 in the cell it will display as -5
--
Gary's Student


"Anna" wrote:

Hi there,

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

Thanks,