How to display only a certain number range

[henryGKN]

I have a column of numbers ranging from -500 up to 50,000... How do I get it to only display numbers between 0 and 1000?

(I already have a formula attached to this column)

Thanks

[Ron Coderre]

Can you clarify what you mean by "display"?
Hide rows for numbers outside that range?
Hide the number in the cells the contain numbers outside that range?
something else?

[Glenn Kennedy]

Can you not siumply use: DATA, FILTER, NUMBER FILTERS, BETWEEN to do this for you? If not, can you post a sheet to make your requirement clearer?

[henryGKN]

I would like the numbers that aren't between 0-1000 to display as 0. Or if that is not possible, just hide the number.

[Glenn Kennedy]

can you post a sample fot eh sort of thing you're dealing with? Excel - not a jpg...

[henryGKN]

What i would like to do is for all the numbers greater than 1000 to either turn to zero or disappear