Solved

Excel File Date Format

Posted on 2016-10-07
6
48 Views
Last Modified: 2016-10-07
I have an excel file which has data for a date column '23-SEP-15'
How to format this to 09/23/2015
0
Comment
Question by:Star79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 12

Expert Comment

by:Missus Miss_Sellaneus
ID: 41834360
Press ctrl+1 to go to cell formatting.  Select "Date" for the category and the format should be the first in the list.
0
 
LVL 12

Expert Comment

by:Missus Miss_Sellaneus
ID: 41834362
No, I take that back. In my case, it's the 5th option "03/14/01". The first option will truncate off the first "0" in the month.
0
 

Author Comment

by:Star79
ID: 41834365
Its not working for me.Book1 is attached.
Book1.xlsx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 12

Expert Comment

by:Missus Miss_Sellaneus
ID: 41834372
Weird.

I was able to fix it by going into the cell, then hitting F2 and Enter.
0
 

Author Comment

by:Star79
ID: 41834374
can you post back that file where you fixed it please
0
 
LVL 12

Accepted Solution

by:
Missus Miss_Sellaneus earned 500 total points
ID: 41834383
Here you go.
fixed-date-format.xlsx
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question