' in excel

C

charlie

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
 
C

Charles Maxson

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.
 
J

Jason Morin

Typically when you enter an apostrophe in front of a
number in Excel, it's a message that the entry is to be
interpreted as text, not a numerical value. It also can
disable a hyperlink. It's simply a signal to Excel that
the following cell entry is be seen as a text string and
not coerced into anything else. But it's redundant to
place it in front of a normal text string.

Per Rob Bovey, the apostrophe (') at the beginning of the
cell "acts as a control character".

HTH
Jason
Atlanta, GA
 
Top