Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 837
  • Last Modified:

Normalize dates in excel

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
roosterup
Asked:
roosterup
  • 2
1 Solution
 
ProfessorJimJamCommented:
put this in column B

=TEXT(A1,"YYYYMMDD")
0
 
ProfessorJimJamCommented:
also you could do this another way

=TEXT(A1,"mm/dd/yyyy")
0
 
David L. HansenProgrammer AnalystCommented:
ProfessorJimJam's solution but refined:
=TEXT(A1, "MM-DD-YYYY")
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now