Hiding negative or positive values (numbers)

[Guest]

Hi , I want to select certain cells and tell them not to display any negative
values , then i want to select other cells and tell them not to display any
positive values

Office microsoft basic edition
Office excel 2003

thanks

 

[Don Guillett]

"not to display" means?

 

[Niek Otten]

Format>Cells>Number tab, choose Custom.
In the Type box, enter:

For not showing negative numbers:
0;;
For not showing positive numbers:
;0-;

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hi , I want to select certain cells and tell them not to display any negative
| values , then i want to select other cells and tell them not to display any
| positive values
|
| Office microsoft basic edition
| Office excel 2003
|
| thanks
|

 

[Guest]

You could also apply conditional formatting to the cells to display, say,
negative numbers, in the same color as the cell's background. This way you
retain the cell's value (useful if you need those values to perform
calculations elsewhere on your sheet), but make it invisible.

Dave

 

[Niek Otten]

Of course conditional formatting is a good alternative. Both methods retain the cell's value, BTW

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| You could also apply conditional formatting to the cells to display, say,
| negative numbers, in the same color as the cell's background. This way you
| retain the cell's value (useful if you need those values to perform
| calculations elsewhere on your sheet), but make it invisible.
|
| Dave
| --
| A hint to posters: Specific, detailed questions are more likely to be
| answered than questions that provide no detail about your problem.
|
|
| "Niek Otten" wrote:
|
| > Format>Cells>Number tab, choose Custom.
| > In the Type box, enter:
| >
| > For not showing negative numbers:
| > 0;;
| > For not showing positive numbers:
| > ;0-;
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | Hi , I want to select certain cells and tell them not to display any negative
| > | values , then i want to select other cells and tell them not to display any
| > | positive values
| > |
| > | Office microsoft basic edition
| > | Office excel 2003
| > |
| > | thanks
| > |
| >
| >
| >

 

[Guest]

Sorry, I didn't realize applying that custom number format would retain the
cell's value.

Dave