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...
 

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

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Converting MM/DD/YYYY into just MM/DD and Sorting 1
Change format to mm dd yyyy hh mm ss 1
Forcing a date entry format of dd/mm/yyyy 1
Converting Birth Date format 1
Date Maniplation 1
How to enter a date in DD-MM-YYYY format 2

Top