Forum Discussion
Copy custom number format to another spreadsheet
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?
SergeiBaklan 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, https://support.microsoft.com/en-us/office/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19 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-a6af-56d4c73c996c
