Excel number formatting thousands is not working

0 votes
I'm attempting to format my numbers in Excel such that they appear as thousands. Replace 1000 with 1 k. Typically, I utilise Excel's numerical format. I put a "space" or a "," after the final digit of my formatting, depending on the language, to get a division of x1000.

In the past, I had format thousands of numbers as: "K" (US) or "K" with no spaces (French, for instance) Format millions in numbers: "M" (US) or "M" with two spaces (French, for instance)

But now it doesn't work, and instead of showing thousands or millions of, it just displays my numbers with a comma or two at the end.

Do you know how to parameterize the cells' format and what it can be related to?

I'm using the "," as the decimal separator and the "" as the thousands separator in my advanced settings.

Because I simply want to alter the format of the cells, I would like not to use a formula. For now, I've created a "mirror" page using =ROUND(Cell/1000000;0) to display Millions, which is a workaround that's not very satisfactory.
Feb 16, 2023 in Others by narikkadan
• 63,420 points
6,804 views

1 answer to this question.

0 votes
Follow these steps:

1- choose cells you want to change the format.

2- Press Ctrl+1 to open the formatting popup (Number tab)

3- select 'Custom'

4- Enter this pattern for converting into thousands with K: #,##0.0, "K"

5- And this pattern for converting into millions with M: #,##0.0,,"M"
answered Feb 16, 2023 by Kithuzzz
• 38,010 points

Related Questions In Others

0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,420 points
666 views
0 votes
1 answer

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,420 points
3,826 views
0 votes
1 answer

Excel SUM function is not working (shows 0), but using Addition (+) works

The values in A1 and A2 are ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,420 points
366 views
0 votes
1 answer

Move_uploaded_file() function is not working

The file will be stored in a ...READ MORE

answered Feb 22, 2022 in Others by Aditya
• 7,680 points
2,701 views
0 votes
1 answer

Excel custom format: What does [$€-2] mean?

The 2 in [$€-2] is a "Numeral ...READ MORE

answered Oct 30, 2022 in Others by narikkadan
• 63,420 points
259 views
0 votes
1 answer

Excel: How to use LEFT function on a Date formatted cell?

Use this: =TEXT(E1,"hh:mm:ss") READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,420 points
370 views
0 votes
1 answer

How to add leading zeros in R?

There are several solutions to this. One of ...READ MORE

answered Apr 30, 2018 in Data Analytics by Sahiti
• 6,370 points
24,014 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
917 views
0 votes
1 answer

TODAY() function not working in Microsoft Excel

Works as shown: Just note that cell c1 ...READ MORE

answered Feb 20, 2023 in Others by Kithuzzz
• 38,010 points
943 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

answered Feb 11, 2023 in Others by Kithuzzz
• 38,010 points
739 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP