Solved

Excel File Date Format

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

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
ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

 
LVL 11

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 11

Accepted Solution

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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

778 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