📺 Don't forget to also watch my other video on this very same topic for more valuable information: ruclips.net/video/72HSE-2pxZg/видео.html 🔍 Got questions? Drop them in the comments below! For a detailed consultation or to have specific, customized questions answered, book a paid session with me at: topmate.io/mehran_vahedi 🌟 If you found this video helpful, please give it a thumbs up, share it, and subscribe to the channel for more insights! Your support means a lot and helps keep this content coming. 🚀 Thanks for watching, and I look forward to seeing your thoughts and questions!
Hi @yuanyuan5319, I'm glad you found the video helpful! Yes, the custom format you mentioned is a great way to display percentages while hiding zeros. To set a custom format as the default in Excel, unfortunately, Excel doesn’t directly allow you to set a custom number format as the default for all new workbooks. However, you can create a template with the custom format already applied to cells, and then use this template for future workbooks. Here’s how you can do it: STEP 1] Open a new workbook and apply your custom format (like 0%;-0;;@) to the cells you need. STEP 2] Save this workbook as an Excel Template (*.xltx). STEP 3] When you need a new workbook, start by opening this template. This way, every new file created from the template will have your preferred formatting in place from the start. Hope this helps, and keep the questions coming! Cheers, Mehran
📺 Don't forget to also watch my other video on this very same topic for more valuable information: ruclips.net/video/72HSE-2pxZg/видео.html
🔍 Got questions? Drop them in the comments below! For a detailed consultation or to have specific, customized questions answered, book a paid session with me at: topmate.io/mehran_vahedi
🌟 If you found this video helpful, please give it a thumbs up, share it, and subscribe to the channel for more insights! Your support means a lot and helps keep this content coming. 🚀
Thanks for watching, and I look forward to seeing your thoughts and questions!
Thank you this is really helpful! Follow your help I find for percentage we can use 0%;-0;;@
Is there any way to make a custom format as default?
Hi @yuanyuan5319,
I'm glad you found the video helpful! Yes, the custom format you mentioned is a great way to display percentages while hiding zeros.
To set a custom format as the default in Excel, unfortunately, Excel doesn’t directly allow you to set a custom number format as the default for all new workbooks. However, you can create a template with the custom format already applied to cells, and then use this template for future workbooks. Here’s how you can do it:
STEP 1] Open a new workbook and apply your custom format (like 0%;-0;;@) to the cells you need.
STEP 2] Save this workbook as an Excel Template (*.xltx).
STEP 3] When you need a new workbook, start by opening this template.
This way, every new file created from the template will have your preferred formatting in place from the start.
Hope this helps, and keep the questions coming!
Cheers, Mehran