View source for Documentation/FAQ/Calc/Formatting/I have a custom number format that I use, but Calc forgets it.

{{DISPLAYTITLE: I have a custom number format that I use, but Calc forgets it.}}

<section begin=question/>
'''I have a custom number format that I use, but Calc forgets it.'''
<section end=question/>

<section begin=answer/>


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 {{menu|File|Templates|Edit}} from the main menu
# Add the number formats as required
# Select {{menu|File|Templates|Save}} from the main menu
# Insert a name for the template and select a template category (e.g., '''My Templates''')
# Click {{button|OK}} to save the template

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

# Select {{menu|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 {{button|Close}}

<section end=answer/>

[[Category:Documentation/FAQ/Calc/Formatting]]