- 3,029,359 hits
Join 3,904 other subscribers
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- Simple Basket Analysis - Formula approach with #Excel 365
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Open an embedded Excel file during a slide show in PowerPoint?
- Case-insensitive SUBSTITUTE???...
- Rename column names in a dynamic way with #Excel #PowerQuery
- How to lookup an image in #Excel
- Copy values from Status Bar in #Excel 365
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Custom Format
Do Not input “-” for zero. Use proper formatting in #Excel
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
Posted in Excel Basic, Excel Tips, Format Tagged Custom Format, Format, Power Query, Replace Values Leave a comment
Add emoji to your numbers 😁 in #Excel
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
Posted in Excel Tips, Format Tagged Custom Format 2 Comments
Highlighting Top X values with Conditional Formatting in #Excel
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
Posted in Excel Tips Tagged Conditional Formatting, Custom Format, Data Validation, LARGE, \ Leave a comment
Display descriptive words instead of numbers with Custom Format in #Excel
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
Posted in Format Tagged Custom Format, IF 2 Comments
#,##0, k or #,##0.0, k ? Why not both?
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
Posted in Excel Tips Tagged Conditional Formatting, Custom Format, MOD 6 Comments