Home |
Search |
Today's Posts |
#1
|
|||
|
|||
' 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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) |