Solved: Format Date data

Hi,

I have the below data to be converted from left to right or vice versa.

col1 col2
Jan-08 200801
Dec-05 200512
Mar-08 200803

I want from one col to another column. Please help me how to change them in excel, not with macros.

Thanks a lot for your help.

Try

=TEXT(A1,"yyyymmdd")

Hi xld,

There are no apparent day values in the source data or in the desired output. One could use:
=TEXT(A1,"yyyymm")
or, simply:
=A1
combined with a custom date format ("yyyymm").

Thanks a lot for your help.
This solved the problem.