Solved

# Normalize dates in excel

Posted on 2014-10-08
525 Views
I have a long column of dates that look like this:

7/1/2008
10/13/2003
11/17/2003
02/25/2002
01/01/1999
5/11/1992
9/30/2013
9/1/2011
10/1/2011

I need leading zeros in front of all the days and months in each cells. Or at least a leading zero on the days under ten. OR is there anyway to convert all these dates into this format YYYYMMDD?
0
Question by:roosterup
• 2

LVL 25

Accepted Solution

ProfessorJimJam earned 500 total points
put this in column B

=TEXT(A1,"YYYYMMDD")
0

LVL 25

Expert Comment

also you could do this another way

=TEXT(A1,"mm/dd/yyyy")
0

LVL 15

Expert Comment

ProfessorJimJam's solution but refined:
=TEXT(A1, "MM-DD-YYYY")
0

## Featured Post

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
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.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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.