cannot change cell format

D

Dean

I have a worksheet that has dates in it. I want to change the format of
those dates. But when i try it they will not change??????
any ideas/solutions are greatly appreciated!!

thanks
 
G

Gord Dibben

Dean

Perhaps the "dates" are Text.

Try Data>Text to Columns>Next>Next. "Column Data Format" check Date and pick
DMY or MDY or whatever is appropriate for the Text.

Finish.

You should get real dates that are formattable.

Gord Dibben Excel MVP
 
Top