| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cell value plus text
On Feb 22, 4:46*pm, mdmackillop
wrote: You can also use Custom Formatting *Format/Cells/Number Custom; Insert the format as 0 " oranges". This will show "oranges", but as it holds a numerical value, it means you can calculate with it as normal. -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile:http://www.thecodecage.com/forumz/member.php?userid=113 View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=67321 Dear mdmackillop A very nice solution. while the cell is numeric and you can conduct the calculation it also shows the text you want. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
| Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
| Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
| linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
| New text added to cell AFTER current text in same cell | Excel Worksheet Functions | |||
Threaded Mode
