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!
==============================================


"Dave" <davekstl@charter.net> wrote in message
news:35lWd.32$Gs5.22@fe03.lga...
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" <ragdyer@cutoutmsn.com> wrote in message
news:eYK$bCaIFHA.580@TK2MSFTNGP15.phx.gbl...
> Try this:
>
> ="Interest Rate "&A1&" %"
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Dave" <davekstl@charter.net> wrote in message
> news:35lWd.32$Gs5.22@fe03.lga...
> 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]

Does this work for you:

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

HTH,

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


"Dave" <davekstl@charter.net> wrote in message
news:0soWd.34316$lN3.10994@fe06.lga...
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" <ragdyer@cutoutmsn.com> wrote in message
news:eYK$bCaIFHA.580@TK2MSFTNGP15.phx.gbl...
> Try this:
>
> ="Interest Rate "&A1&" %"
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Dave" <davekstl@charter.net> wrote in message
> news:35lWd.32$Gs5.22@fe03.lga...
> 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 did it :-)

Thanks!!


"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:%23AaIkFcIFHA.2640@TK2MSFTNGP09.phx.gbl...
> Does this work for you:
>
> ="Interest Rate "&TEXT(A1,"#0.00%")
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Dave" <davekstl@charter.net> wrote in message
> news:0soWd.34316$lN3.10994@fe06.lga...
> 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" <ragdyer@cutoutmsn.com> wrote in message
> news:eYK$bCaIFHA.580@TK2MSFTNGP15.phx.gbl...
>> Try this:
>>
>> ="Interest Rate "&A1&" %"
>> --
>>
>> HTH,
>>
>> RD
>> ==============================================
>> Please keep all correspondence within the Group, so all may benefit!
>> ==============================================
>>
>>
>> "Dave" <davekstl@charter.net> wrote in message
>> news:35lWd.32$Gs5.22@fe03.lga...
>> 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]

Appreciate the feed-back.
--

Regards,

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

"Dave" <davekstl@charter.net> wrote in message
news:q7pWd.78$wV.71@fe03.lga...
That did it :-)

Thanks!!


"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:%23AaIkFcIFHA.2640@TK2MSFTNGP09.phx.gbl...
> Does this work for you:
>
> ="Interest Rate "&TEXT(A1,"#0.00%")
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Dave" <davekstl@charter.net> wrote in message
> news:0soWd.34316$lN3.10994@fe06.lga...
> 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" <ragdyer@cutoutmsn.com> wrote in message
> news:eYK$bCaIFHA.580@TK2MSFTNGP15.phx.gbl...
>> Try this:
>>
>> ="Interest Rate "&A1&" %"
>> --
>>
>> HTH,
>>
>> RD
>> ==============================================
>> Please keep all correspondence within the Group, so all may benefit!
>> ==============================================
>>
>>
>> "Dave" <davekstl@charter.net> wrote in message
>> news:35lWd.32$Gs5.22@fe03.lga...
>> 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
>>
>>
>>
>
>
>