How to define custom number format?

There are several data formats defined already. It this Excel tutorial you will learn how to deafine a custom one.

Number format creation

For you to set own custom number format in Excel, you first need a number in the cell that looks like this:

custom number format data table

Note: The number can of course, be anything numerical.

Mark all the numbers.

custom number format mark numbers.

Right click on the marked area (1), and choose format cells (2).

custom number format right click

Click custom and set the customized number under type.

 

Custom formant examples

To display 123456.78 as 123456.8 use ####.#

.123 as 0.1 use 0.# 

5.25 as 5 1/4 use # ???/???

 

Note: You can even format colors. Just write [color]

How to Format Date and Time?

How to Easily Format Date and Time in Excel Format of date and time can be tough, but it will easily be performed together with me, follow me as I format date and time.

Date formatting

Click on a cell (1), type in =DATE(2014(year);10(month);05(day)) (2), and press enter.

Format Date type date

Time formatting

Click on another empty cell (1), and type in =TIME(hour;minutes;seconds) (2), and finally press enter.

Format Time type time

Right click on the time, and choose format cells.

Format Date and Time format cells

Click on date (1), and choose desired format (2), before clicking ok.

Format Date choose format

Repeat previous step, but this time choose time (1), the type you want (2), and then press ok (3).

Format time choose time format

With that knowledge you will be able to use date duration calculator without any problems.