# Trying to figure out how to track remaining work in Excel

#### TheOneTheDave

##### New Member
I've tried for quite a while to figure out the nomenclature of what I'm trying to do, and I am coming up at a bit of a loss. I hate being the guy that asks the same question, but I can't seem to figure out how to formulate my search to return the information I'm looking for. The long and short is, work has tasked me (a fumbling beginner) with creating an Excel based war board to track projects across multiple markets. I have been able to research and add in some automation, but I am completely lost in how to make Excel display X/X in a cell without it trying to divide the values.

To add a bit of context;
I have 20 total projects in one market. I have permits back on 12 of them. I am hoping to get Excel to output 12/20 onto the overview sheet in the workbook. I've found a bit about the MOD function, but I'm not sure if that is going to work the way that I need it to. Is there anyone who has encountered this?

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Hi & welcome to MrExcel.

how to make Excel display X/X in a cell without it trying to divide the values.
Just use the text format on the cells to be affected before you enter any data.

Thank you for the quick reply, and the warm welcome!

Will that still hold its formatting if its pulling data from 2 different cells? I have one cell that has a total count of projects based on a sum formula, and then another that counts which cells have conditional formatting using a COUNTIF formula. Using the method above, will the cell still hold the formatting, or is there something else I would need to do?

The TEXT formatting is strictly for text. As shown on the image attached, even data entered as a formula is converted to text and is therefore not evaluated.

Replies
32
Views
346
Replies
6
Views
176
Replies
1
Views
107
Replies
20
Views
584
Replies
12
Views
403

1,203,068
Messages
6,053,343
Members
444,654
Latest member
Rich Cohen

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back