Excel - Easy Way to Hide All Negative Values in Excel - Episode 553

Описание: Microsoft Excel Tutorial: Easy Way to Hide All Negative Values in Excel.
Welcome back to another MrExcel netcast! In yesterday's episode, I showed you how to use the IF function to hide any negative values in your spreadsheet. But did you know there's a non-formula way to achieve the same result? In today's video, I'll show you how to format away negatives using a simple number format.

First, let's go back to the original formula from two days ago. I've selected all the cells with both positive and negative values. Now, instead of using a formula, we'll use a number format. To do this, go to Format Cells and select the Number tab. You'll see that the cells are currently formatted as a number. We want to change this to a custom format, so scroll down and select Custom.

In the custom format box, you can enter up to four different number formats, separated by a semicolon. The first format is for positive or zero values, the second is for negative values, the third is for zeros, and the fourth is for text. In this case, we only need to enter two formats. The first one will be for positive or zero values, and the second one will be for negative values. So, we'll enter "0;" which means to show the number as is if it's positive or zero, but show nothing if it's negative. When we click OK, all the positive numbers will remain visible, but the negative numbers will disappear.

This is a great way to quickly hide all the negative numbers in your spreadsheet without having to change your formula. It's a simple number format that can save you time and effort. Thanks for watching this netcast from MrExcel. Don't forget to subscribe to our channel for more helpful tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...

Table of Contents
(00:00) Hide Negative Values without using a formula
(00:34) Custom Number Format
(00:54) Use Semi-colon for an empty negative zone
(01:20) Clicking Like really helps the algorithm


#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
Custom type
Format cell
Formula formatting
Hide negative numbers
IF function
Negative numbers
Negative values
Non-formula way
Number format
Number tag
Positive numbers

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...



In todays podcast, a custom number format that shows positive values and zeros, but hides the negative values. Episode 553 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!