thanks but i need the formula link to stay becasue the number in the version
i am trying to use are constantly changing (i used a slightly oversimplified
example in my original question)

"Gary''s Student" wrote:

Select the cell and copy it it. Then paste/special/as value elsewhere in the
worksheet. At this point you can select portions of the new cell in the
formula bar and format them as you choose.
--
Gary's Student


"tinester" wrote:

I have a formula that pulls in numbers into a text string but i want to
underline or bold the numbers being pulled in and selected parts of the text.
Is this possible?

eg cell formula
="john is "&A1&" years old" where cell A1 is 10
returns
"john is 10 years old"
ideally i want the 10 to be bold and the old to be underlined

even if the cell the number is being drawn from (A1 in this case) is bold or
underlined the format is not pulled into the result of the formula

many thanks

(nb i have excel 2002)