The single apostrophe (') has long been a qualifer in spreadsheets to
designate the entry as text even it is numbers or a formula.... try typing
('=2+1). Anyway, if you really want to see apostrophe, simply put two in
(''something) and you should get your result.
--
Charles
www.officezealot.com
"charlie" wrote in message
...
when i type 'something in a cell. ' - as a single quote
it always display only something, without a '
anyone knows why?
does that ' mean anything?
thx