Copy custom number format to another spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2078038%22%20slang%3D%22en-US%22%3ECopy%20custom%20number%20format%20to%20another%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2078038%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20custom%20number%20formant%20which%20I%20need%20to%20apply%20to%20a%20number%20of%20spreadsheets.%3C%2FP%3E%3CP%3EIs%20there%20a%20easy%20way%20I%20can%20apply%20this%20to%20all%20spreadsheets%3B%20at%20the%20moment%20I%20have%20to%20go%20into%20each%20one%20and%20retype%20the%20entry%20in%20the%20custom%20format%20box.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2078038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2078097%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20custom%20number%20format%20to%20another%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2078097%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F935787%22%20target%3D%22_blank%22%3E%40maw444%3C%2FA%3E%26nbsp%3BDid%20you%20try%20Format%20Painter%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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 

@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...