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

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


.

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!