Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Insert Thousands Separators to Long Numbers in Excel Cells

Date:2019-10-17 Author:Cordelia

While processing data in Excel, we may need to type some long numbers in Excel cells. As we all know, a long number can be very easily mistaken. So can we add thousands separators to make them more intuitive?

The method is quite simple.

1. Select the data that you want to insert thousands separators and press Ctrl+1.

How to Insert Thousands Separators to Long Numbers in Excel Cells

2. Or you can right-click the selected area and choose Format Cells…

How to Insert Thousands Separators to Long Numbers in Excel Cells

3. The Format Cells window will then pop out. Choose Number in the list of Category and check Use 1000 Separator (,)

How to Insert Thousands Separators to Long Numbers in Excel Cells

4. Hit OK. You can see the thousands separators have been added to the numbers in selected cells.

How to Insert Thousands Separators to Long Numbers in Excel Cells

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

2 thoughts on “How to Insert Thousands Separators to Long Numbers in Excel Cells”

  1. mobile legends bang bang email says:

    You actually make it seem so easy with your presentation but I find this matter to be really something that I
    think I would never understand. It seems too complicated
    and very broad for me. I am looking forward for your next post, I will try to get the hang of it!

    1. Olivia says:

      Just stay tuned to learn more office tips.

Leave a Reply

Your email address will not be published. Required fields are marked *