Jan 20 2021 01:36 AM
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.
Jan 20 2021 01:49 AM
@maw444 Did you try Format Painter?
Jan 20 2021 11:18 AM
@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
Jan 20 2021 01:54 PM
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...