Copy custom number format to another spreadsheet

Copper 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 

@maw444 

If that's about new workbooks you may create the template to start from, https://support.microsoft.com/en-us/office/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d... If we speak about existing workbooks you may create cell style with desired format and copy it from one workbook to another https://support.microsoft.com/en-us/office/copy-cell-styles-from-another-workbook-d5a2db01-ed42-440a...