Date Issues

[Bigyaw]

Hi All

I've got an excel document that is not recognizing that 3 columns are date fields and hence am unable to change it to the format I would like.
however when I use F2 and Enter, it does recognize it.

Please help as i've got several worksheets with this issue and it'll be very tideouse to be doing this one at a time!

Thanks in advance

[NBVC]

Select the column and go to data|Text to columns and click Finish

Now you should be able to change the format.