Change Numbers Into Dates In Microsoft Office 2007 Excel Format

Asked By Lawrence M Crawford 0 points N/A Posted on - 08/06/2017

Hello everyone, I want to change the format of the numbers I inserted into the excel sheet to be displayed in date format. I am currently working on Microsoft office 2007 Excel. Please guide me through the steps.

• Status: Open
• Question Views: 303
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Hardware
• Question Tags: Microsoft office

Answered By Noel Sammy 0 points N/A #302145

Change Numbers Into Dates In Microsoft Office 2007 Excel Format

Insert the data in the Excel sheet.

In the data tab select for the text-to-columns option.

Select the range you want to convert. Click twice the next button in the wizard.

After it selects the date format, you want to change.

Click on finish, and you will see the changes in the data.

About Noel Sammy

Questions
3

Answers
10

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/06/2017
• Question Category: Hardware

Answered By Sharath Reddy 590495 points N/A #303899

Change Numbers Into Dates In Microsoft Office 2007 Excel Format

If you want change the type of the content of a cell in Microsoft Office Excel, you just need to format the cell and change its type. There are twelve categories to choose from: general, number, currency, accounting, date, time, percentage, fraction, scientific, text, special, and custom. Since you want to change the type to date, just select date.

To change the type or category of a cell, right-click on the cell where you want to display the date then select “Format Cells.”

On the next screen, in “Number” tab, select “Date” on the left pane under “Category” then on the right, select the format how you want the date to appear then click “OK.”

After this, any number you type on that cell will be converted into date in the format you selected.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 10/01/2017
• Question Category: Hardware