It has been quite sometime since I last posted a video on YouTube and to tell you the honest truth, I’m not sure why I don’t do it more often.  What is even more funny is that my wife has been all over me about doing videos saying that it’s really just the best way to help people learn.  This week I’m going to run a quick experiment and I’ll be posting a 60 second video every night for the remainder of  the week on my YouTube channel just to see if my wife was actually right (and yes I know, she is normally right about everything).  I’m going to see what kind of feedback I get from the experiment and if it is positive,  I’m going to try and run more short 60 second videos throughout the week, every week.

This week I will be focussing my efforts on custom number formatting tricks that I’ve learnt throughout the years.  The majority of the tricks that I will be making videos for have already been captured in my article 5 Incredible Number Formatting Tricks That Will Impress Your Boss.  I feel like this will be a great way to kick off and really dive into my Excel in 60 Seconds video series.

Without further ado, let’s dive into learning how to display numbers in thousands in Excel.

How to Display Numbers in Thousands in Excel

Summary

Custom number formatting is an Excellent way to appeal to and change the way your data looks to satisfy the user of the spreadsheet.  Some people like to see numbers in thousands, others in Millions and of course they may even want to see the numbers just as they are.

What other tricks have you personally used when it comes to custom number formatting in Excel?  Let me know in the comments.