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" wrote in message
...
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