Hi

Is there a way to not show decimal figures depending on what that
decimal is?

For example.
I will have only the following in cells
Whole numbers (232, 246 etc)
Numbers with one decimal place with values of only x.1 or x.5

I want to ONLY show numbers that are
a) Whole numbers or
b) Numbers with decimal places of x.5

IE I would only want to show 232, 232.5, 240.5, 250 but NOT 242.1 or
267.1 etc.

I hope this makes sense. The x.1 decimal numbers are used for a minor
calculation for ranking purposes but are not needed for display
purposes, whereas the x.5 numbers are!

I just wondered if there was something clever I could do with Cell/
Number formatting

Thanks
Neil