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 lets you change the format of the number inside the cell. This is required because of excel reads date and Time as a general number.

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  keyboard shortcut  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.

Related Articles:

How to use the IF and Conditional formatting in Excel

How to do Conditional Formatting with formula in Excel

How to convert decimal Seconds into time format in Excel

How to use the Conditional Formatting using VBA in Microsoft Excel

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel

How to use the SUMIF Function in Excel

Leave a Reply

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

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 Youtube