Help inserting a Cell Value in a Text Cell

[Dave]

I have a cell at the top of a column with Text identifying the column below.

I want to use the value in another cell in this text field.

Example Cell A1 = 5 Text Cell B1 = Interest Rate "A1" %

So the end result would be Interest Rate 5 %

Example Cell A1 = 8 Text Cell B1 = Interest Rate "A1" %

So the end result would be Interest Rate 8 %

How do I do this?

Thanks

 

[RagDyeR]

Try this:

="Interest Rate "&A1&" %"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a cell at the top of a column with Text identifying the column below.

I want to use the value in another cell in this text field.

Example Cell A1 = 5 Text Cell B1 = Interest Rate "A1" %

So the end result would be Interest Rate 5 %

Example Cell A1 = 8 Text Cell B1 = Interest Rate "A1" %

So the end result would be Interest Rate 8 %

How do I do this?

Thanks

 

[Dave]

That worked -THANKS

But another question, the number comes out as .049999999

How do I show it as a Formated percentage number ?

Thanks again!

 

[RagDyeR]

Does this work for you:

="Interest Rate "&TEXT(A1,"#0.00%")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


That worked -THANKS

But another question, the number comes out as .049999999

How do I show it as a Formated percentage number ?

Thanks again!

 

[Dave]

That did it

Thanks!!

Does this work for you:

="Interest Rate "&TEXT(A1,"#0.00%")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


That worked -THANKS

But another question, the number comes out as .049999999

How do I show it as a Formated percentage number ?

Thanks again!

 

[RagDyeR]

Appreciate the feed-back.