I found the solution to my question.
What I needed to do was simply "clean up" my cells. I did this by using a formula. To cleanup a cell -
1. Click an empty cell next to the cell you wish to "clean".
2. Enter =CLEAN(cell you wish to clean) into the formula bar.
3. Thats it!
Bookmarks