| Home |
| Search |
| Today's Posts |
|
#4
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to convert list of formulas in text format to output value | Excel Discussion (Misc queries) | |||
| can you format a cell so that formulas will be turned off | Excel Discussion (Misc queries) | |||
| Compare text in cell to custom text format?? | Excel Discussion (Misc queries) | |||
| Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
| Formulas Based on Cell Format | Excel Discussion (Misc queries) | |||
Threaded Mode
