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