Uploaded July 2022 | Updated September 2026, 21 hours ago
Join 400,000+ professionals in our courses: xelplus.com/courses
Microsoft Excel 365 is getting a new feature that allows you to keep leading zeros. There is no need for workarounds anymore. Just unchecking a simple checkmark in the options of Excel. This way you can enter zero values before a number and they remain in the cell. No more disappearing zeros in Excel!
Availability: This feature is currently in Office 365 Insider Beta.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #office365
Join 400,000+ professionals in our courses: xelplus.com/courses
Microsoft Excel 365 is getting a new feature that allows you to keep leading zeros. There is no need for workarounds anymore. Just unchecking a simple checkmark in the options of Excel. This way you can enter zero values before a number and they remain in the cell. No more disappearing zeros in Excel!
Availability: This feature is currently in Office 365 Insider Beta.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #office365




![The 1-Formula Fix for Excelβs Messiest Tables
Learn Python in Excel: https://www.xelplus.com/course/python-in-excel/
Sales data split across monthly columns? Heres how to reshape it into one clean table, with month, sales, and units each in their own column, using Python inside Excel.
=PY
pd.wide_to_long(sales_data, stubnames=[sales,units], i=sales rep, j=month, sep , suffix=.+).reset_index()
- Type =PY and press Tab to activate Python mode
- wide_to_long turns repeated column groups (like sales_Jan, units_Jan) into rows
- stubnames lists the values youre tracking
- i is your identifier column, like sales rep
- j names the new column that holds the month
- sep matches the separator in your source headers
- suffix=.+ means the leftover text can be anything
- reset_index() keeps everything aligned
- Right-click the Python output and choose Excel Value to drop it into cells
Add a new month to your source data and the table updates on its own.
Uses the pandas wide_to_long function. Check the pandas docs for the full reference.
π¨ Subscribe to Between the Sheets newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
π Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π² Letβs connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/in/leilagharani
#Excel The 1-Formula Fix for Excelβs Messiest Tables](https://i.ytimg.com/vi/aUlGfk7kst0/mqdefault.jpg)





