How to only show decimals if there are any

Thanks for your responses!!

Vince - the custom format you specify puts a zero after the end of a whole number, so if a department has 10 people, it would show up as 10.0. Since most departments have no part-time people, I did not want to burden the report with lots of extra .0's.

Tim - wow! I SHOULD put some crazy stuff in this report like your formula since the person who created these worksheets has forced me to learn more excel than I cared to know. Unfortunately, this report has MANY columns and worksheets that I want to have these formats in, so I don't think putting in an extra column for each column that I want to format would be feasible. However, I learned another Excel function - "RIGHT". I had to look that up because I wasn't sure what that was doing.

Thanks again for your help.

Use the General format. It's as simple as that.