D Diane New Member Sep 26, 2011 #1 I want to use a cell to show completed vs. due. So...I have 12 tasks and 2 are done. I want to show it as 2/12. But when I do that I get either 40586 or 12-Feb(date). How can I format this to show the 2/12 that I want? Thanks!
I want to use a cell to show completed vs. due. So...I have 12 tasks and 2 are done. I want to show it as 2/12. But when I do that I get either 40586 or 12-Feb(date). How can I format this to show the 2/12 that I want? Thanks!
D Diane New Member Sep 26, 2011 #4 Whooops! Ok..this worked until I got to 3/12. Then it became 1/4. Apparently it's dividing to the smallest FRACTION. Any other ideas?
Whooops! Ok..this worked until I got to 3/12. Then it became 1/4. Apparently it's dividing to the smallest FRACTION. Any other ideas?
