How to convert numbers to dates in Excel
Converting digital data into dates in Excel is a pretty useful trick for people who use this software. Sometimes your date data cells are converted into digital data cells, then if you do not know how to turn it back into a date, please refer to the following tutorial tips of TipsMake.com .
How to convert numbers to dates in Excel Picture 1
For instructions on how to convert numbers to dates in Excel, TipsMake.com asks permission based on the following example. You can look at the image below and see the data box displayed as a number but in fact it is originally date data.
Because dates in Excel are encrypted as numeric data so Excel can easily manage and calculate. But if you enter data as a date, the data box will display as a date by default, unless you accidentally convert it to numeric data so it will display as numeric data. same as in the picture.
Now we need to convert it to a date view.
How to convert numbers to dates in Excel Picture 2
To do this, first you need to highlight the data cells you want to convert numbers to dates in Excel.
Then you open the Home ribbon on the toolbar and find the Number in this ribbon.
Click on the data type option and there will be a drop-down list. In that list, Short Date and Long Date are the date data type options that Excel provides.
In particular, Short Date will display in the form of the date NN / TT / NNNN, and Long Date, you will see it clearly displayed full day month and year.
Just below the name is also displayed when you convert into the data format types, look at which you can see how your data will display.
How to convert numbers to dates in Excel Picture 3
After selecting the data type, you will see your data box is displayed as a date. If you see the data box with the form of consecutive # signs as shown below, then don't worry, it is not an error at all but just because the width of the data box is not enough to display date data.
How to convert numbers to dates in Excel Picture 4
You just need to black out the data column does not contain enough then let the mouse pointer on the position between the two columns behind the highlighted column and click to drag it to the side.
How to convert numbers to dates in Excel Picture 5
With the appropriate width, your data box will display the full date entered.
How to convert numbers to dates in Excel Picture 6
Thank you for reading our article TipsMake.com on how to convert numbers to dates in Excel. Wish you can do it successfully !!!
You should read it
- How to convert a sequence of numbers into dates in Excel
- Share how to fix dates being converted to numbers in Excel
- DATEVALUE function - Functions to convert text format dates to serial numbers in Excel
- Convert numbers to text in Excel
- How to convert Apple Numbers documents to Microsoft Excel
- How to convert numbers into words in Excel?
- How to format dates in Excel
- How to convert money into words in Excel, without an add-in, supports both 32-bit and 64-bit Excel
- How to convert negative numbers to positive numbers Excel
- How to convert numbers into text in Excel is great
- DATEVALUE function - The function converts dates into numbers in Excel
- How to Convert .Numbers to .Xls