I have a custom number format that I use, but Calc forgets it.
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
I have a custom number format that I use, but Calc forgets it.
For Calc to remember the preferred number formats, add them to a template:
- Create a new empty spreadsheet document or open an existing template by selecting File → Templates → Edit from the main menu
- Add the number formats as required
- Select File → Templates → Save from the main menu
- Insert a name for the template and select a template category (e.g., My Templates)
- Click OK to save the template
To have them available with every newly created spreadsheet you need to make this template your default template:
- Select File → Templates → Organize from the main menu
- Select the template from the list of templates (double click the template categories to show all containing template files)
- Right-click the template file name and select Set as default template
- Click Close