I was working on my fantasy football rankings when I ran into a quirk with excel.

I was trying to do a find and replace on a comma, and it would not let me.

1. I could see the comma was there.
2. I wanted to find it, and replace it with a blank.
3. Excel would not let me search the values, only the formulas.

When I did search the formulas for "," I got the message "Microsoft Office Excel cannot find the data you're searching for"


Now I was getting frustrated. I could see the comma, but I could not remove it. It turns out the comma really wasn't there.


1. In the formula bar you can see there is no comma.
2. Yet the comma is showing up in the cell value. It must be formatting.
3. Right click the column.
4. Format Cells.



Choose "Number" and set the decimal places to 0, and the comma is removed.