In this article, we will learn about how to use the Custom format cell option in Excel.
Custom format option let’s you change the format of the number inside the cell. This is required because of excel reads date and Time as General numbers.
You can access the Number option in the Home tab to change the format as shown below.
There are some shortcuts to convert a number into different formats.
|General number||Ctrl + Shift + ~|
|Currency format||Ctrl Shift $|
|Percentage format||Ctrl Shift %|
|Scientific format||Ctrl + Shift + ^|
|Date format||Ctrl + Shift + #|
|Time format||Ctrl + Shift + @|
|Custom formats||Ctrl + 1|
These are some of the format options of the number -2 in different formats.
Now there’s one more thing. Numbers represent so many values in a text as Date, Time and currency. So Sometimes you need to change the format cell type to required field type using Format cell option.
Use the format cell option shown below or Ctrl + 1 shortcut keyboard key that will open a full Format cell dialog box
Changing the format you will get
As you can see from the above snapshot that the number in general representation is converted to date format.
Hope you understood how to change the format or custom format cell in Excel. Explore more articles on number representation in Excel. Please state your queries in the comment box below. We will assist you with that
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.