| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number format codes for negative numbers | Excel Discussion (Misc queries) | |||
| question driving me nuts | New Users to Excel | |||
| How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) | |||
| LEAVE BLANK IF NEGATIVE | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Linear Mode
