PDA

View Full Version : Solved: Format Date data



venkiatmarut
12-10-2009, 09:57 AM
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.

Bob Phillips
12-10-2009, 10:55 AM
Try

=TEXT(A1,"yyyymmdd")

macropod
12-10-2009, 11:33 AM
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").

venkiatmarut
12-11-2009, 01:57 AM
Thanks a lot for your help.
This solved the problem.