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
|