Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help inserting a Cell Value in a Text Cell
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 |
#2
|
|||
|
|||
Try this:
="Interest Rate "&A1&" %" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dave" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... Try this: ="Interest Rate "&A1&" %" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dave" wrote in message ... 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 |
#4
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... Try this: ="Interest Rate "&A1&" %" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dave" wrote in message ... 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 |
#5
|
|||
|
|||
That did it :-)
Thanks!! "RagDyeR" wrote in message ... 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" wrote in message ... 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" wrote in message ... Try this: ="Interest Rate "&A1&" %" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dave" wrote in message ... 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 |
#6
|
|||
|
|||
Appreciate the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Dave" wrote in message ... That did it :-) Thanks!! "RagDyeR" wrote in message ... 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" wrote in message ... 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" wrote in message ... Try this: ="Interest Rate "&A1&" %" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dave" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
how to hyperlink text to a cell | New Users to Excel | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |