Solved

Excel File Date Format

Posted on 2016-10-07
6
44 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

734 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