How To Use Serial Numbers

  • Home
  • / How To Use Serial Numbers

It is based on UK regional settings. If your regional settings are not compatible, this session will be harder to follow; we have already seen that excel interprets date as a number.

Entry into a Cell (Excel Numerical Order)

Once you have made an entry into a cell that entry will be interpreted according to the Excel’s internal rules. If it is interpreted as a date it will attract a date serial number. The serial number is what you will see in that cell if you strip away the date formatting.

How To Use Serial Numbers 1

How to Use Date & Serial Numbers in Excel

To understand how to use serial numbers, it is probably necessary to look at some examples. For example, in cell a2 type zero one forward slash zero one nine zero this date, the first of January 1900 is the date when excels data serial number kicks off each day that elapses the serial number goes up by one.

How To Use Serial Numbers 2

If I type in o2 forward-slash or one four slash and one nine zero, we can see the serial number has gone up to two. If I typed in a more recent date in 2019, we could see that the serial number is approaching 44,000.

Having dates set up in excel with this date serial number makes the manipulation addition, subtraction, and all sorts of other operations much easier to perform on dates for excel. To recognize a date has to be entered in a certain way.

How To Use Serial Numbers 3 (1)

How To Use Serial Numbers 3 (2)

The Intuitive One’s Will Automatically Be Interpreted

Fortunately, there is a choice of ways, and a lot of the intuitive ones will automatically be interpreted as dates; as you can see, we have entered dates with forwarding slashes and hyphens so far. We have sent a date with the month and letters providing. We have the first three letters that will work. We can enter dates without the day.

How To Use Serial Numbers 4 (1)

How To Use Serial Numbers 4 (2)

How To Use Serial Numbers 4 (3)

Type Number without Space(How to Put Numbering in Excel Cell)

Now type on October 19 with no spaces, and we can see that this attracts the date of the 1st of October, one of the rules that excel has when it interprets dates. If you don’t give a day, it will default to the first of that month, we can use spaces in some circumstances, and they don’t always work, so for example, if I type in a1 October 19 that works.

Use Number with Spaces

If I use numbers with spaces and type in a1 10 2019, then the data isn’t interpreted as a date; it’s just been interpreted as text in terms of months you can type in oct for October; you could type in the whole month either we’ll return to the date. If I type in the month and year, excel recognizes that as a date.

If I type in an equal sign followed by a number, a backslash, and another number, excel will still see a date here because the cell already has a custom date format. If the cell didn’t have date format and I typed in the same equals ten divided by 19, excel would recognize that as a normal number.

We can see that the time 6 am has been returned this time. If I type in 0.5 controls, enter its midday; if I type in 0.75, it’s actually 6 p.m. time effectively works, like a fraction of the serial number of one excel interprets.

As to which century we’re in, if I was to type on October 29, excel recognizes that as the first of October 2029. If I type on October 30, then excel recognizes that as 1930. So, any year 30 or above will be recognized as the last century in the year 29 or below excel will recognize as the current century. Thank you!

Write your comment Here