cannot change cell format

G

Guest

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
 

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