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
|