What version of Excel?

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

--
Susan Ramlet
**please reply to the newsgroup so others may benefit**


"bbane" wrote in message
...
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?