Discover the secret trick to applying Excel number formatting in your Microsoft Project formulas! 🧑💻 Whether you're creating custom fields or formatting data for professional reporting, this video walks you through:
Using the FORMAT function in Microsoft Project
Transforming durations into clean, readable values (like months with decimals!)
Borrowing powerful Excel custom formatting codes for your Project formulas
Learn how to seamlessly integrate Excel-style formatting into your Microsoft Project workflow and create reusable, polished templates for your organization. 💡
Here's the formula from the video: Format([Duration]/(20 * [Minutes Per Day]),"#,##0.00") & " months"
📈 Key Takeaways:
Apply Excel formatting hacks for durations and numbers
Avoid common pitfalls (like using number fields for text)
Impress your team with professional, custom fields
If you found this video helpful, don’t forget to like, share, and subscribe for more Microsoft Project tips and tricks! 🚀
Want personalized training for your team? Leave a comment below or contact me directly!
For more Microsoft Project tips and tricks check out my blog
📰 https://www.dalehowardmvp.com/microsoft-project-tips-and-tricks/
💎Download your Quick Access toolbar for Free Here https://www.dalehowardmvp.com/free-quick-access-toolbar
✅ Download your Free Quality filters here. https://www.dalehowardmvp.com/free-microsoft-project-quality-filters/
🖋️ If you find these tips helpful, please leave a comment or if you have other topics/questions about Microsoft Project leave it in the comments.
✉ If you have a topic or question you would like me to create a video about you can submit your questions at https://www.dalehowardmvp.com/contact-dale/
To see other people's questions and my answers over the last 20 years, here's some links for the Microsoft Project message boards.
✓ Microsoft: https://techcommunity.microsoft.com/t5/project/ct-p/Project
▶️ LinkedIn: https://www.linkedin.com/groups/25618/
If you're looking for a full course on Microsoft Project, check out one my OnDemand courses and you can be a Schedule Hero in just a week!
▶️ https://www.dalehowardmvp.com/microsoft-project-training/
🌐 My Website: https://www.dalehowardmvp.com/
#project #MicrosoftProject #msprojectonline #msprojectonline #projecttraining #microsoftprojecttraining #freeprojecttraining #projecttips #projecttipsandtricks