Date problem

[Tom]

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

 

[K Dales]

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.

 

[Thomas Struebi]

The problem is, that I can't format the Excel sheet with a certain
number format, because each country uses its own settins, so I need to
format the column with the NumberFormat "Short Date".

Tom