Prevent "[n]/[n]" from simplifying to "1"

I have a task tracker that needs to display the number of people that have completed a task out of how many are supposed to complete the task and what percentage that is. The names are in column B and the tasks are in row 2. The percentage is located in the cell below the fraction. Both cells are coded as such:

Formula:

=TEXT(SUM(C6:C1048576)/COUNTA($B$6:$B$1048576),"###/###") 

and

Formula:

 =C3

I have to use the TEXT function to prevent the fraction from reducing. However, when the fraction reaches unity, e.g. 38/38, it still displays it as a 1. How do I get it to display [n]/[n]? Additionally, the percentage cell will not display the fraction as a percentage, even though I have formatted it for percentage, it just displays the fraction. How can I get it to convert the fraction into a percentage? CAVEAT: I cannot change the aesthetics of this excel file--the format is being used by other units as well to feed to a higher unit. Therefore, I can't just use the 3 cell approach and other solutions like that. Also, VBA cannot be used because, inevitably, the end user (not me) will likely not press the "enable macros" button. Thanks

Chris

Correction: Using the TEXT function actually didn't prevent the fractions from simplifying--must have misread a 3/4 as a 2/4. I have removed the TEXT function so it is now coded:

Formula:

=SUM(C6:C1048576)/COUNTA($B$6:$B$1048576)

On the bright side, now that the value is a number and not text, the percentage cell does not need fixing.

why don't you utilise two different formulae - one for displaying fractions, and the other for displaying percentages...

for displaying fractions, use:

=SUM(C6:C1048576)&"/"&COUNTA($B$6:$B$1048576)

and for percentage:

=SUM(C6:C1048576)/COUNTA($B$6:$B$1048576)

wouldn't that work for you?