How to Open Office Calculator and Capitalize Months

You can capitalize months when creating a calendar using OpenOffice Calc.

OpenOffice comes with a spreadsheet calculator application called OpenOffice Calc. This program works similar to Microsoft Excel and other spreadsheet applications. You can define fields as numerical for calculations and as textual for organizational or identification purposes. You can add calendar dates to OpenOffice Calc, but it will automatically format the months by capitalizing the month's first letter and leaving the rest of the letters as lowercase. If you want to capitalize the full month's name, you must override the default functionality.

Instructions

Start OpenOffice Calc

1. Start OpenOffice by clicking on the OpenOffice icon on your desktop.

2. Create a new OpenOffice Calc spreadsheet by clicking on "Spreadsheet" in the startup menu.

3. Input data into the spreadsheet by clicking on spreadsheet cells and typing information into each cell.

Disable Autoinput

1. Press ALT-T to open the "Tools" menu.

2. Click on the "Cell Contents" option within the menu that appears.

3. Uncheck the word "Autoinput" in the subsequent menu so that OpenOffice Calc no longer automatically formats months by capitalizing only the first letter.

4. Enter months inside cells using uppercase or lowercase, according to your needs. OpenOffice Calc will leave the case exactly as you type it.

Change Case

1. Types months in uppercase or lowercase inside all appropriate cells.

2. Highlight all cells containing months by pressing down and moving your mouse over the cells.

3. Click ALT-O to open the "Format" menu and select "Change Case" from within the menu.

4. Click on "Uppercase" from within the "Change Case" menu to automatically change all text within the highlighted cells to uppercase.

References

• Discovering OpenOffice.org: Autofill in Excel is AutoInput in OpenOffice [OpenOffice Calc]
• OpenOffice Documentation: OpenOffice Calc Tutorial