• Microsoft Office
  • Microsoft Windows
  • Other Software
  • 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
  • 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
  • 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
  • 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!

6
61 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

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

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.