Home » Category » Microsoft Excel

Microsoft Excel: ' in excel

205| Thu, 22 May 2008 22:14:00 GMT| anonymous| Comments (3)
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

Keywords & Tags: excel, microsoft

URL: http://www.developertags.com/microsoft-excel/10/
 
«« Prev - Next »» 3 helpful answers below.
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" <charlie...discussions.microsoft.com> wrote in message
news:53980654-8066-4D0E-85B1-538FD378F4FE...microsoft.com...
> 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

charles | Thu, 22 May 2008 22:15:00 GMT |

it means the entry is in text form

charlie <charlie...discussions.microsoft.com> wrote in message
news:53980654-8066-4D0E-85B1-538FD378F4FE...microsoft.com...
> 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

hbb | Thu, 22 May 2008 22:16:00 GMT |

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

jason | Thu, 22 May 2008 22:17:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories