Leading Apostrophe in Excel
Submitted by j.winder on December 7, 2010 - 5:31pm.
In an effort to remain compatible with Lotus 1-2-3, Microsoft Excel supports "leading characters" -- for example, the apostrophe ('), which signals a text field. In Excel these "leading characters" are not actually characters at all, even though they appear in the formula bar. They can be activated automatically via the Transition Navigation Keys setting (under Options | Advanced), which exposes the full set of possible values: apostrophe (left-justified text), quote mark (right-justified text), carat (centered text), backslash (repeated text), or blank (non-text).
- Login to post comments
- Read more
