Hiding negative or positive values (numbers)
 

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

Hiding negative or positive values (numbers)
 

"not to display" means?

--
Don Guillett
SalesAid Software

"ryan" wrote in message
...
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

Hiding negative or positive values (numbers)
 

FormatCellsNumber 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


"ryan" wrote in message ...
| 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
|

Hiding negative or positive values (numbers)
 

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:

FormatCellsNumber 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


"ryan" wrote in message ...
| 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
|

Hiding negative or positive values (numbers)
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" wrote in message ...
| 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:
|
| FormatCellsNumber 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
|
|
| "ryan" wrote in message ...
| | 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
| |
|
|
|

Hiding negative or positive values (numbers)
 

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

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:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" wrote in message ...
| 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:
|
| FormatCellsNumber 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
|
|
| "ryan" wrote in message ...
| | 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
| |
|
|
|