Dear Sir Peo,

Why make it so hard and error prone,

maybe D-- is trying to gain skills in excel...
try this
=TEXT(SUM(A1:A3),"0")& " Months"
A1:A3 contains number of *months* not Dates...

regards,
driller
--
*****
birds of the same feather flock together..



"Peo Sjoblom" wrote:

Why make it so hard and error prone, why not just use 2 cells, one with 6
and another with months? Or just use a custom format like General" Months"
and just type in a number, then use

=SUM(range)


Otherwise you might have to do something like

=SUMPRODUCT(--(0&SUBSTITUTE(Range,"months","")))

if months can be the only text value, if not post back


--
Regards,

Peo Sjoblom



"D--" wrote in message
...
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-