format cells from mm/dd/yyyy to yyyy

B

bbane

I am trying to convert the format of a column of cells from mm/dd/yyyy to
yyyy. I used format cells, custom, and yyyy. The cell will change to the yyyy
format if I double click on it and then click on another cell. However,
trying to to do this with 49,000 cells is unreasonable. Any Ideas?
 
S

Susan Ramlet

What version of Excel?

Did you select the entire column first before using format cells?
 
G

Gord Dibben

Sounds like the dates are being seen as text by Excel.

Select the column then Data>Text to Columns>Next>Next>Column Data
Format>Date>MDY>Finish

Now Format to YYYY

Any joy?


Gord Dibben MS Excel MVP
 
B

bbane

Perfect! It worked. Thank you very much!
Bbane

Gord Dibben said:
Sounds like the dates are being seen as text by Excel.

Select the column then Data>Text to Columns>Next>Next>Column Data
Format>Date>MDY>Finish

Now Format to YYYY

Any joy?


Gord Dibben MS Excel MVP
Click to expand...
 
Top