Prevent OpenOffice Calc from Capitalizing First Letter

Posted February 17, 2004 by Al Banks in OpenOffice

The following instructions explain how to bypass the automatic capitalization ‘feature’ included in OpenOffice Calc.


When inputting text into a cell, if you do not want the first letter to be capitalized, start the text entry with a single quotation mark (‘).

For example, entering hello!
will result in the cell contents:
Hello!

To avoid this, enter:'hello!
resulting in cell contents:hello!

The Conversation

Follow the reactions below and share your own thoughts.