Custom format it to
00 "months"

Now if you typed say 7 in the cell it will display it as "07 months" and you
could still sum it the way you would otherwise sum a number


"D--" wrote:

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-