Tag Archives: Custom Format

Do Not input “-” for zero. Use proper formatting in #Excel

Posted on December 5, 2021 by MF

Do you input a hyphen to represent zero? If you do, please stop doing so in the future. The proper way of displaying “-” for zero is to apply relevant cell format to it. E.g. Using Accounting format with no … Continue reading →

Rate this:

Posted in Excel Basic, Excel Tips, Format | Tagged , , , | Leave a comment

Add emoji to your numbers 😁 in #Excel

Posted on January 9, 2021 by MF

Is it possible in #Excel? Of course, as you have just seen it! 😁 Indeed, it’s easier than you may have thought about. We can do it by custom format. First of all, select the cells that you want to … Continue reading →

Rate this:

Posted in Excel Tips, Format | Tagged | 2 Comments

Highlighting Top X values with Conditional Formatting in #Excel

Posted on December 15, 2018 by MF

Well… think this topic is too simple?  How about doing this with a dropdown menu to make the Top X a dynamic one? with Icon Set? You may download a Sample File to follow along. Let’s start with the basics … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

Display descriptive words instead of numbers with Custom Format in #Excel

Posted on June 14, 2018 by MF

Sometimes we want to add a descriptive like “Good Job” for figures above target; “Work Harder” for those below… like the following screenshot: To many people, the top-of-mind solution should be using IF function. =IF(A2>0, “Good Job”, IF(A2=0, “Just Met”,”Work … Continue reading →

Rate this:

Posted in Format | Tagged , | 2 Comments

#,##0, k or #,##0.0, k ? Why not both?

Posted on December 16, 2017 by MF

Conditional Custom Formatting in #Excel Got the following question: This gives me £28.8 K (if 28800 is input) and £28.0 K if 28000 is input. I was rather hoping that if there was no decimal after the thousand, ie £28 … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments