unable to format cell date

B

Billy

I am unable to apply date formats from the dialog box. Right clicking the
cell and using the Format...Cell...number is to no avail.
 
G

Gord Dibben

Billy

Is it possible the dates are entered as Text, not real dates?

In an adjacent column enter =ISNUMBER(cellref)

If you get FALSE, the date is not a real date.

Select the dates and Data>Text to Columns>Next>Next "Column Data Format"
Select "Date" and format type. Finish.

Gord Dibben Excel MVP
 
Top