• ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
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
37
287 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
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • 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
Products
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Windows 10 Education Key Global Windows 10 Education Key Global
    Rated 4.84 out of 5
    $9.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Buy Windows 11 Home CD Key Global Buy Windows 11 Home CD Key Global
    Rated 4.73 out of 5
    $6.00
  • Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 4.72 out of 5
    $20.00
  • Windows Server2008 R2 Remote Desktop Services user connections (20)cal Windows Server2008 R2 Remote Desktop Services user connections (20)cal $29.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.