• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Simple way to convert number series to dates in Excel

0 Comments

Converting numbers to data is a common task for Excel users. However, sometimes date cells (in the file you received) are converted to numeric data. So how do you convert these numbers back to the correct date format? This article from Buffcom.net will guide you on how to convert number series to dates in Excel.

Step 1: Click on the Number button on the Home tab

You can observe the data table based on the following example to know the steps to perform. The data is currently displayed as numbers, but it is actually date data.

Because dates in Excel are encoded as numeric data so that Excel can easily manage and calculate them. But if you originally enter the data as dates, the data cell will default to displaying as a date. So unless you convert it to numeric data, it will only display as a date.

Simple way to convert number series to dates inTherefore, we need to convert it to display as a date.

To do this, first, you need to select the data cells in Excel that you want to convert from numbers to dates.

Then, you select the Home tab on the toolbar and choose the Number option at the bottom.

Step 2: Choose Short Date under the Number menu

When you click on the data type option, a drop-down list will appear. In that list, there is Short Date and Long Date to choose from the date format that Excel provides.

Short Date will display as a date in the format MM/DD/YYYY. And Long Date will display the full day, date, and year clearly.

For example, we choose the Short Date format. Below you can see how your data will be displayed.

Simple way to convert number series to dates inAfter selecting the appropriate data type, click on it. Immediately, the data cell will be converted to a date format. Please see the image below for more details.

Simple way to convert number series to dates inWith these simple two steps, you can easily convert to the desired date data. This method will help you reduce the data needed to be entered into the spreadsheet to save time.

This article has helped you convert number series to date data in Excel. Hopefully, this article will provide useful information for you. Good luck with your work!

Rate this post
36
280 Views
How to delete content, formatting, comments, and hyperlinks in Excel cells?PrevHow to delete content, formatting, comments, and hyperlinks in Excel cells?March 12, 2023
Calculating Percentage and Discount Percentage in ExcelMarch 12, 2023Calculating Percentage and Discount Percentage in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.00
Products
  • Buy Windows 11 Home CD Key Global Buy Windows 11 Home CD Key Global
    Rated 4.73 out of 5
    $6.00
  • Windows Server 2016 Datacenter Key Global Windows Server 2016 Datacenter Key Global
    Rated 4.74 out of 5
    $10.00
  • Office 2019 Professional Plus Key Global Bind to your Microsoft Account Office 2019 Professional Plus Key Global Bind to your Microsoft Account
    Rated 4.97 out of 5
    $49.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Windows 10 Pro Key Global Genuine Key Windows 10 Pro Key Global Genuine Key
    Rated 4.78 out of 5
    $6.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Microsoft Visual Studio 2022 Professional Key Microsoft Visual Studio 2022 Professional Key $19.00
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
  • Windows Server 2016 Essentials Key Global Windows Server 2016 Essentials Key Global
    Rated 4.79 out of 5
    $10.00
  • Windows Server 2019 Essentials Key Global Windows Server 2019 Essentials Key Global
    Rated 4.71 out of 5
    $7.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.