' in excel
 

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

it means the entry is in text form


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

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

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

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