|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 17th, 2009, 05:55 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) 
|
|
#2
June 17th, 2009, 05:59 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)
|
|
#3
June 17th, 2009, 06:05 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)
|
|
#4
June 17th, 2009, 06:10 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
