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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top