Excel is a great software. It’s easy to use (at least the basic functions…) and very flexible. Unfortunately, coming with the flexibility, users tend to misuse the options and disobey certain basic rules. One thing I’ve seen multiple times is to transport important information in the formatting of a cell. It might be the background… Continue reading Return Number Format Codes in Excel – 4 Ways to Get the Formatting Code from a Cell
Excel provides many default number formats. But often, these formats are not enough. For example: You want to display number in thousands or millions? Or have a thousands separator for percentage values? Or show a plus sign for positive values? In such case, you need to create a custom number format. In this article, you… Continue reading Custom Number Formats: Big Guide, Popular Codes and a Free Download
Sometimes you don’t want the comma “,” as a thousands separator, but rather a full stop “.”. Or you don’t want the full stop as the decimal separator. Changing these two separators in Office is easy: You can either do it system-wide or override the system settings.
You are changing the cell format, for example from “text” to “number” and nothing happens? Or the other way around, you want to enter a phone number but Excel automatically converts it to a number? Unfortunately, Excel is very unpredictable when it comes to text/number formatting. Here is what you should do in order to… Continue reading Force Cell to Text/Number Format in Excel: Easy Tricks!
Sometimes, you want to create random values in Excel. There is a simple formula to generate random numbers: RAND. If you type =RAND() into a cell, you’ll get a number between 0 and 1. So what do you do, if you want to have random number between 20 and 50 for example?
There are many reasons why you might want to hide zero values in Excel. For example when working with cell links, Excel shows a 0 even if the source cell is blank. Or because it might look more professional. Whatever reason you have, there are different methods for hiding zero values. Depending on the scope… Continue reading Hide Zero Values in Excel: 3 Simple Methods