I'll bet Bernard meant ISNUMBER


Gord

On Tue, 6 Jan 2009 13:12:50 -0400, "Bernard Liengme"
wrote:

Let us first determine if the entries are text or formatted dates.
If the fist date is in A1 what does the formula =ISNUMERIC(A1) return?
If TRUE then all you need do is reformat the cells