What is actually in Column 1? And what are your results
when you try setting the NumberFormat? Need to know to
say what is wrong. One example: If column 1 is actually
entered as text, rather than a date value (number), it
will not matter what number format you apply, it will
always show as typed.


-----Original Message-----
Hi

I'd like to verfiy that the user works with the date
format "Short Date",
but I don't know how format this. The following function
works:

Debug.Print Format(#10/4/2004#,"Short Date")


but this code fails:

Columns(1).NumberFormat = "Short Date"


What am I doing wrong? Many thanks in advance.

Tom


.