Date Tranformation

[wenyuanalive]

Hey guys,

I have a question about date transfer.

In an excel spreadsheet, cells(1,1) = 28Feb90. How can I manipulate this data to get cells(1,2) = 199002(meaning Feb, 1990)? It looks like Excel can't read the short 'Feb' as February.

The data ranges from 31Jan90 t0 40Apr12. So I was wondering if there is a quick way to transfer. Or should I write a user-defined function?

Thank you and enjoy the rest of the weekend.

Sean

 

[JoeMo]

Excel Workbook
	A	B
1	28Feb90	199002
2	31Jan90	199001
3	04Apr12	201204
Sheet1

 

[wenyuanalive]

Excel Workbook
	A	B
1	28Feb90	199002
2	31Jan90	199001
3	04Apr12	201204
Sheet1

Thanks for your reply!

I found a simpler way to do it: B1 = =TEXT(A1, "yyyymm")