I have a custom number format that I use, but Calc forgets it.

I have a custom number format that I use, but Calc forgets it.

2.x

For Calc to remember the preferred number formats, add them to a template:

1. Create a new empty spreadsheet document or open an existing template by selecting File → Templates → Edit from the main menu
2. Add the number formats as required
3. Select File → Templates → Save from the main menu
4. Insert a name for the template and select a template category (e.g., My Templates)
5. Click  OK  to save the template

To have them available with every newly created spreadsheet you need to make this template your default template:

1. Select File → Templates → Organize from the main menu
2. Select the template from the list of templates (double click the template categories to show all containing template files)
3. Right-click the template file name and select Set as default template
4. Click  Close