ChemistB - you ROCK! Thanks so much for your help.
ChemistB - you ROCK! Thanks so much for your help.
A word of caution about using the custom format.
Even though the cell may DISPLAY "Not Complete", the true underlying value of the cell is still 0.
So, if you have downstream calculations looking for cells that contain "Not Complete", you may have problems!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks