Show Thousands K and Millions M (Cool Excel Hack)

In this video I show you a simple custom formatting technique to display 1,000 as 1k and 1,000,000 as 1m. Works on any number.

TIME CODES (click the link to go directly to that spot in the video)
(0:00) The limitations of standard number formatting  
(1:02) Show all numbers as millions (m)
(1:54) Show all numbers as thousands (k)
(2:37) Show millions as m, thousands as k and anything smaller as-is

😃 If you found this video useful,  don't forget to give a thumbs up.

😃 What ONE thing resonated with you the most? Let me know by adding a quick COMMENT or question below.

Go get ‘em.

😃 USEFUL LINKS:
Share this Video:
Show Thousands K and Millions M (Cool...

😃 SUBSCRIBE if you want to see more content like this
https://www.seevid.ir/c/JasonMorrel...

😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
https://trst.com.au/microsoft-trouble...

😃 ABOUT THE PRESENTER:  
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.

😃 LET'S CONNECT!
https://officemastery.com (free training on the blog)
Facebook: officemastery
LinkedIn: jkmorrell
jasonmorrell

Have a fantastic day!

• #howto_style
• #excel_thousands_k
• #excel_thousands_format
• #excel_millions_format
• #excel_millions_m
• #custom_format_thousands
• #custom_format_millions
• #02riv
• #jason_morrell
• #how_to
• #how_do_i
• #in_excel
• #excel_2016
• #excel_2013