excel - Preserve a custom number format without having applied it -


i have observed if click on cell ->manage cell formats->customformats->add new format new format saved, if reformat cell standard text format, previous custom format deleted excel.

can add custom number format in excel , retain without applying cell?

you can apply format cell in hidden sheet.


Comments

Popular posts from this blog

java - Unable to make sub reports with Jasper -

Save and close a word document by giving a name in R -

scala - play framework: Modules were resolved with conflicting cross-version suffixes -