Copy custom number format to another spreadsheet

New Contributor

I have a custom number formant which I need to apply to a number of spreadsheets.

Is there a easy way I can apply this to all spreadsheets; at the moment I have to go into each one and retype the entry in the custom format box.

3 Replies

@maw444 Did you try Format Painter?

@Sergei Baklan  Yes I did - perhaps I did not explain myself.


Nearly every spreadsheet we use has a certain number format  - at the moment I copy and paste from one spread sheet to another - I'd like it so that it's automatically available in any spreadsheet that I open 


If that's about new workbooks you may create the template to start from, If we speak about existing workbooks you may create cell style with desired format and copy it from one workbook to another