Thread: ' in excel
View Single Post
  #2   Report Post  
Charles Maxson
 
Posts: n/a
Default

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