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.