Solved

Excel File Date Format

Posted on 2016-10-07
6
25 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
  • 4
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Missus Miss_Sellaneus
Comment Utility
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 11

Expert Comment

by:Missus Miss_Sellaneus
Comment Utility
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
Comment Utility
Its not working for me.Book1 is attached.
Book1.xlsx
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 11

Expert Comment

by:Missus Miss_Sellaneus
Comment Utility
Weird.

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

Author Comment

by:Star79
Comment Utility
can you post back that file where you fixed it please
0
 
LVL 11

Accepted Solution

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

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Macro to Send Appointment from Excel 1 29
VBA to look in every sheet and 2 20
Macro 3 14
Formula to convert ranked data 2 9
My experience with Windows 10 over a one year period and suggestions for smooth operation
Outlook Free & Paid Tools
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now