Prevent OpenOffice Calc from capitalizing first letter

Contributed by abanks February 17, 2004  
Tagged: OpenOffice

How to work around the automatic capitalization ‘feature’.

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!