0
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Because a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoBecause a date is a number. It can be displayed with words for the month and day of the week, but a date is a number. It also means calculations can be done with dates, like finding out how many days are between two dates or by adding an amount of days to a date or taking away an amount of days from a date. If they were actually text, then those things could not be done. It would also sort dates alphabetically, which would mean dates would be in the wrong order. All dates starting with the digit 1 would come before anything starting with the digit 2, which means a date like 12/2/10 would come before 2/2/10. So there are lots of reasons why dates are numbers and not text.
Add your answer:
Earn +20 pts
What is the value of an alembic Excel 5 string bass?
what is the value of an alembic excel 5 string bass
What is used to locate a string in excel?
You can use the find command of the FIND function.
Does Excel store dates and times using text?
No. Dates and times are stored as numbers in Excel.
What should you do if you have accidentally deleted Microsoft Excel?
You should be able to do a system restore, if that doesnt work simply reinstall the excel from your Microsoft Office.
Can you format dates in Excel?
yes
What are the functions Microsoft Excel?
Functions allow you to perform some mathematical or string procedures to other cells.
What Excel property help to design date in style?
Formatting. There are many ways of formatting dates in Excel.
How do you change the contents of a cell to currency?
I'll assume your not talking about Excel. In ASP.Net, the string format is {0:c}. This will convert in numeric string value to currency Ex.: 12345.67 will become $12345.67
Does the CONCATENATE function in Excel require a text argument?
Normally yes, but it will actually take numbers and combine them into a text string.
When is the beginning of time in Excel?
In terms of dates, computers usually start dates for the 1st of January 1900. This is the way it works in Excel. For times, it starts at 00:00.
Is Excel a database intended to manipulate string variables?
It is a spreadsheet application and mainly deals with numbers, but it has databasing capabilities and can manipulate strings.
What is the function of pre-defined function LEN in Excel?
The LEN function returns the length of the specified string.=LEN(text)text is the string to return the length for.EXAMPLE:=LEN(word) will return the value of 4.
