Thousand and million formatting for negative numbers excel googlesheets

0 votes
Hello I currently use this formatting to show big numbers as either 1.2M or 20K (instead of 1 200 000 ans 20 000):

[>999999]0.00,,\M;[>999]0.0,\K;0.0,\K

I have an issue with negative numbers, I can show -20K but how can I also show -20M?
Sep 24, 2022 in Others by Kithuzzz
• 38,020 points
1,242 views

1 answer to this question.

0 votes

Its not possible. What you could do is add a formula like this or you could use conditional formatting along with multiple formats like this.

answered Sep 25, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

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

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

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

Calculate slope and intercept value for logarithmic trendline as excel

You missed Math.log() for ln() in Excel. ...READ MORE

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

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

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

How to remove gridlines on select cells in Google Sheets?

The google sheets don't have an exact ...READ MORE

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

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,720 points
912 views
0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

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

Excel Issue- custom format for Turkish currency

What about: #.##0,00 [$₺-tr-TR] Where #.##0,00 € would do for ...READ MORE

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

How to define excel SUMIFS criteria considering any text and numbers?

It essentially ignores column C's missing entry ...READ MORE

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