NumberFormat question
 

Hi

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

Columns(1).NumberFormat = "Short Date"

How to get this work? Many thanks in advance.

Tom

NumberFormat question
 

Hi
try
Columns(1).NumberFormat = "MM/DD/YY"

--
Regards
Frank Kabel
Frankfurt, Germany

"Tom" schrieb im Newsbeitrag
...
Hi

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

Columns(1).NumberFormat = "Short Date"

How to get this work? Many thanks in advance.

Tom

NumberFormat question
 

See your last post from yesterday. Never post new since you have same post
before...
Regards.
Jorge
"Tom" escreveu na mensagem
...
Hi

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

Columns(1).NumberFormat = "Short Date"

How to get this work? Many thanks in advance.

Tom