Formula req
 

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

Formula req
 

Hi try
= your-formula & " Weeks"

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

santaviga wrote:
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

Formula req
 

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)

wrote in message
ups.com...
Hi try
= your-formula & " Weeks"

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

santaviga wrote:
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

Formula req
 

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

Mark

" wrote:

Hi try
= your-formula & " Weeks"

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

santaviga wrote:
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

Formula req
 

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

Thanks


Mark

"Bob Phillips" wrote:

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)

wrote in message
ups.com...
Hi try
= your-formula & " Weeks"

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

santaviga wrote:
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

Formula req
 

menu FormatCellsCustom

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)

"santaviga" wrote in message
...
Sorry Bob, little confused, can explain how to format the cell as 0 "
Weeks"

Thanks


Mark

"Bob Phillips" wrote:

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)

wrote in message
ups.com...
Hi try
= your-formula & " Weeks"

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

santaviga wrote:
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