how do i format a cell to use text and formulas
 

heres what im trying to do .. i want to create a note template that would be
something simillar to this:

sally sold 18 units of seashells

I want the 18 part reference a cell in the spreadsheet (the cell that
already is calculating how many units sally is selling)

how do i format a cell to use text and formulas
 

Brian, with 18 entered to cell A1 try the below..

="sally sold " & A1 & " units of seashells"


If this post helps click Yes
---------------
Jacob Skaria


"brianDY" wrote:

heres what im trying to do .. i want to create a note template that would be
something simillar to this:

sally sold 18 units of seashells

I want the 18 part reference a cell in the spreadsheet (the cell that
already is calculating how many units sally is selling)

how do i format a cell to use text and formulas
 

awesome thank you .. just one additional question I need the number in A1 to
be a 3 place percentage and its not coming out that way?

"Jacob Skaria" wrote:

Brian, with 18 entered to cell A1 try the below..

="sally sold " & A1 & " units of seashells"


If this post helps click Yes
---------------
Jacob Skaria


"brianDY" wrote:

heres what im trying to do .. i want to create a note template that would be
something simillar to this:

sally sold 18 units of seashells

I want the 18 part reference a cell in the spreadsheet (the cell that
already is calculating how many units sally is selling)

how do i format a cell to use text and formulas
 

Try this with a % value in A1

="sally sold " & TEXT(A1,"#%") & " units of seashells"

OR

="sally sold " & TEXT(A1,"#.00%") & " units of seashells"
(with decimals)

If this post helps click Yes
---------------
Jacob Skaria


"brianDY" wrote:

heres what im trying to do .. i want to create a note template that would be
something simillar to this:

sally sold 18 units of seashells

I want the 18 part reference a cell in the spreadsheet (the cell that
already is calculating how many units sally is selling)