Best way to apply a custom number format to all files

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Hi

What do you recommend as the best way to create a custom number format for
any number I enter in Excel and be able to apply that number format quickly
on any new number I enter in any new Excel file I create?

Should I create a recorded macro in the personal file and record the steps
to create the custom number format or should I create a style for it and
store it in the default book template? (or is there a better way than either
of the above)?

Thank you very much

Craig
 
Craig

How about using the format painter button, that will copy all your formats
from one cell to another.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign custom number format to the ribbon 0
Defualt number formats When Opening CSV Files 5
custom number format 1
Custom Number Format 1
custom number format 1
2007: Number format <> Number format 1
Custom Number Format for text 8
how do I add phone number format as a permanent custom format? 3

Back
Top