View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how can i change european date format to american

If your dates are real, which I suspect is not the case, =ISNUMBER(cellref) wil
return TRUE.

If not real....FALSE


Gord

On Mon, 27 Nov 2006 17:43:01 -0800, pclifford99
wrote:

there goes one clump is hair. i am confused by your solution so don't even
know where/how to start.


Gord Dibben MS Excel MVP