Convert Date Format of 7/29/04 to Date Format of 072904

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi...I need to convert a data with a slash to a date without the slash and a preceding zero, if the date does not begin with 10, 11, or 12. I've successfully resolved this problem in 3 steps by converting the date to 29-Jul-04 and then writing a separate formula in 3 cells for =MONTH(A), etc., and then concatenating the string, but it still doesn't add the zero and this method is quite lengthy...is there a formatting option in Format Cells that I'm overlooking? Custom formatting doesn't work in this case either....I appreciate any help you have.
Thank you,
Petra
 
=TEXT(A1,"mmddyy")

--
HTH

-------

Bob Phillips
Petra said:
Hi...I need to convert a data with a slash to a date without the slash and
Click to expand...
a preceding zero, if the date does not begin with 10, 11, or 12. I've
successfully resolved this problem in 3 steps by converting the date to
29-Jul-04 and then writing a separate formula in 3 cells for =MONTH(A),
etc., and then concatenating the string, but it still doesn't add the zero
and this method is quite lengthy...is there a formatting option in Format
Cells that I'm overlooking? Custom formatting doesn't work in this case
either....I appreciate any help you have.
 
Back
Top