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
| |
|
|
|