Difference between revisions of "Documentation/FAQ/Calc/Formatting/I have a custom number format that I use, but Calc forgets it."
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
m |
m |
||
| Line 6: | Line 6: | ||
<section begin=answer/> | <section begin=answer/> | ||
| − | + | ||
For Calc to remember the preferred number formats, add them to a template: | For Calc to remember the preferred number formats, add them to a template: | ||
Latest revision as of 14:52, 2 October 2021
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
