Excel number format scale number by ten thousand or hundred thousand

0 votes
Is there a method to display 10,000 or 100,000 in Excel as one number?

The number is scaled by one thousand when there is a comma at the end of a number format. If a number is formatted as "#," 2000 will show up as "2."

Is it possible to make "20,000" or "200,000" look like the number "2"? What number format should I use for this?
Oct 17, 2022 in Others by Kithuzzz
• 38,020 points
2,650 views

1 answer to this question.

0 votes

In the MSExcel spreadsheet, Right Click on the cell. Then from properties:

Click on Format Cells -> Click on Tab “Number" -> "Custom"

Now, enter the following text in the "Type" Box.

0"."0,

I hope this helps you.

answered Oct 18, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Number format in excel: Showing % value without multiplying with 100

You just need to select Custom from ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,720 points
1,504 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,720 points
14,404 views
0 votes
0 answers

Format an Excel column (or cell) as Text in C#?

When I copy values from a data ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,020 points
991 views
0 votes
0 answers

Excel: How to Sort or filter text by specific word or words?

Even if the term is used in ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 38,020 points
569 views
0 votes
1 answer

How to format numbers in excel in crores or lacks

Try this: =TEXT(A1/10000000,"#,### \cr") READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,720 points
880 views
0 votes
1 answer

Using office scripts to read superScripts characters from a cell in excel online

My understanding is that superscript and subscript ...READ MORE

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

Adding a percentage sign to a number field in Excel

Format these cells with custom format ?\% READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,720 points
385 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
1,105 views
0 votes
1 answer

How can I convert excel to PDF by Libreoffice and keep all format from excel file?

"Times New Roman" typeface does not have ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,599 views
0 votes
1 answer

Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,720 points
2,404 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