Ask Your Question

Revision history [back]

You only need to prefix input with ' apostrophe if it could be interpreted as numeric (number, date, time, ...) and then the apostrophe shows just in the Input Bar, not as cell content. Otherwise, for text that could not be interpreted as numeric just enter the text. If you prefix text that could not be interpreted as some numeric input then the leading apostrophe is assumed to be part of the text entered. If the cell was already formatted as Text prior to input then all input entered will be text content, including a leading apostrophe, no matter whether the input could be interpreted as numeric or not.