Automate a positive number

I have excel 2007 and use it for golf handicaps. The cells show a positive number for the handicaps. (IE; a negative 6 is shown as 6) We have one golfer that actually has a positive handicap. How can I show that number with a plus automatically and all of the others with nothing but the number? (IE; a positive number is shown as this +1) I'm sure I might need to use an IF statement to get this accomplished. I do have a practice file top send if needed.

35 33 39 36 41 38 35 38 34 35 10 41 39 80 35.5 -0.5 0

OK, here's a sample of what I have. The 10 left most numbers are the golf scores. The next number is the number of scores they have for the calculations. The next number is the highest number not to be used to calculate the handicap. The next number is the 2nd highest number not used to calculate the handicap. The next number is those two numbers added together. The next number is the 10 scores added together minus the 2 highest scores divided by 8. The next number is the previous number minus 36. And the last number is what I want to show as a +1.

I did try the "+"0;0; and got a blank cell. But thanks for the info.

I also tried this +0;0; and I still get a blank cell. But thanks for the info.

Can I send a sample file???? It does have all the formulas I use in it.

I tried this in again and I did get a number 1 in the cell, which is what I want it to show, but it didn't show the plus sign.

I don't see a paper clip to attach a file with. How do I send it to you?

Thank you for the response, but Excel 2007 doesn't show Personalizations to use for formatting a cell.

I tried this in the Custom area for formatting the cell and I either get a blank cell, or I get a 1 but without the + sign.

sample scores.xls

Here is the file with all of the formulas I use.

If R1 is -0.5, S1 should be what? +1

If R1 is 0.0, S1 should be what? 0

If Ris is 0.5, S1 should be what? 1

What I received has cells A thru Q with the plus sign and cells R and S have just the number. I need cell S to show a plus sign IF cell R has a negative number in it.

John, I only need the cell to show a plus sign if cell R shows a negative sign. But thank you for the response.

Golf is a game of opposites, if you want the ball to go higher, you hit down on it, if you want the ball to go left, you hit it with a right swing path and so on. Hence, the golf scores are the same, if you are a great golfer, you have a positive handicap, but if you play like I do with an 8 handicap, you show it as just a number. It is a negative number, but is only shown as a number. Thanks again for everyone's help with this.

OK, great. I do have something that works. I have to change a few formulas around to make it work for al of the other scores too, but it does work correctly. Thanks again for everyones help with tihs. Around the world people are helping people with problems. Thanks again. I'll close the thread.

When I figure out how to close it.

I just did that to everyone's response. Thanks Glenn for informing of this added feature.

Which is why I gave all of them a good reputation. Thanks again to everyone for your help. Automation is the way I like to do things in big files in Excel.