I am trying to create a template that will contain a large number of tables. The tables will contain formulas in some cells, and a very specific number format in all cells.

I've attached an example. I created the first table and filled in the data so that I could get the number format and calculations in place. Then I copied the table and changed all the numbers to zeros. (The "Expression is faulty" message shows up because of the zero in the denominator. We can live with that because the zeros will disappear once the table is filled out, of course I'd prefer an "if/then" style formula, but that is beyond my skill level at this point in time!)

My questions:

Will number format "hold" if I remove the cell contents? (Do I need those zeros as "placeholders?")

What is the easiest way to assure that the people who USE the template don't lose the number format and/or formulas?

Is there a way to "lock" the number format of a cell and still allow the user to change the cell contents?

I am still very new at this (obviously) and I will need to make a large number of these tables, so i want to do it in the most efficient manner possible.