How to Use the Custom Format Cell in Excel

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.

Format Shortcut key
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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube