How can you setup a cell with text and assign a value to that cell so when
you sum the columns, the value computes. For example, I have a cell contract
terms with a text value of "6 months", how do I setup the cell so it's value
for formulas is "6" so it will compute the sum of the contracts based on the
months?

Thanks, D-