format cells from mm/dd/yyyy to yyyy

  • Thread starter Thread starter bbane
  • Start date Start date
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?
 
What version of Excel?

Did you select the entire column first before using format cells?
 
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
 
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...
 
Back
Top