Ah. You can use a custom number format to suppress display of negative
numbers. A number format has four elements, for positives, negatives, zero,
and text. Suppose your format would be "0.0". To suppress negatives, leave
the negative slot blank in the custom number format:
0.0;;0.0;@
The @ just means treat text as it is entered. More on Excel's number
formats:
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.