I have observed that if I click on cell *->Manage cell formats->CustomFormats->Add New format* the new format is saved, but if I reformat the cell with a standard text format, the previous custom format is deleted from Excel.

Can I add a custom number format in Excel and retain it without applying it immediately to any cell?