Home |
Search |
Today's Posts |
#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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |