Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

In this lesson, I’m going to be showing you how to:

  1. Understand what is the thousand separator in Excel
  2. Use the thousand separator in Excel

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered anything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel

Or go back to:

Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24 – How to SORT data in ASCENDING order in Excel

Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22 – How to RENAME a worksheet in Excel

Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

10 thoughts on “Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel”

  1. Hi there,
    Another good Excell training, It’s easy to understand even for a junior high school student.
    I have one question though. In the demonstration, while formatting cells for a thousand separator, I saw some numbers below the thousand separator checkbox being in red colour and others in black. What do they signify? (check 4.48 timeframe example)

    Thank you for your great work and best wishes.

    Reply
    • Thank you James for your lovely comment.
      Now coming to your question (very good question by the way, well observed).
      In my video at 4.48 minutes, under the thousand separator, this section shows how you would want the negative numbers on your spreadsheet to look like. So from the list of options you can see some are red and some are black, whichever one you select, Excel will automatically turn the cell value to be formatted like so. I do recommend choosing the red one, then all your negative numbers on the worksheet will have emphasis to give you attention.

      Hope this helps you out even further 🙂

      Habib (ICT tutor)

      Reply
  2. Thanks for a clear tutorial once again. This function is certainly a great way to make the numbers in Excel easier to see particularly if you are dealing with large numbers.

    Reply
  3. Hi Habib. Thank you for another lesson. I get to learn that for a task actually can have different way to make it done! Today I have learnt another new way to get this task done.

    Reply
    • Yes Janet, in the ICT world you can always complete a task or use a function more than one way. You just got to figure out, which method is better for you 🙂

      Habib (ICT Tutor)

      Reply
  4. thanks for another great post. You really know what the average user needs help and assistance on. I look forward to my next training. I’m on my way to being an excel pro!

    Reply
    • I certainly do Jamie, as I have learners of all levels and know what an average learner would benefit from, hence I have created these lovely tutorials to meet their needs 🙂

      Habib (ICT Tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap