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)
|