unable to format cell date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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

Similar Threads

Column Date Format 1
Formatting Text to Numbers for Dates 2
Formatting Text to Numbers for Dates 1
Cell Format 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional formatting in Excel 2010 2
2007: Number format <> Number format 1
Format cells dialog 3

Back
Top