Thread: ' in excel
View Single Post
  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.