Yeep! and every time he type ISNUMERIC (which seems better name to him) he
gets a #NAME? error and he mutters to himself profound philosophical words.
Happy New Year, Gord
--
Bernard
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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