Formula req

[Guest]

I have cells with the following formula in them
(=INT(TODAY()-INDEX('Galashiels Tea Fund'!$1:$1,1,MATCH("x",'Galashiels Tea
Fund'!4:4)))/7) this returns a number in the cell with reference to the date,
Is there a way I can also insert a text to go along with the number at the
end of the formula. e.g. (6 Weeks) the 6 is generated by the current formula
all I need is to add weeks as text.


Thanks



Mark

 

[paul.robinson]

Hi try
= your-formula & " Weeks"

where your-formula is the one you wrote down
regards
Paul

 

[Bob Phillips]

Format the cell as

0 " Weeks"

this will preserve the number if you want to use it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

No that no working, its putting weeks at the end but disrupting the
calculation, the cell is formatted as a number.

Mark

 

[Guest]

Sorry Bob, little confused, can explain how to format the cell as 0 " Weeks"

Thanks


Mark

 

[Bob Phillips]

menu Format>Cells>Custom

type '0 " Weeks"' in the Type box (but without the surrounding
single-quotes that I supplied).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)