I have columns C and H in a spreasheet that have date validation format of
mm/dd/yr. My co-workers in China and Japan are not able to input and date in
these columns even in the right date format while the offices in Europe,
Singapore, Taiwan, Thailand.. are. Can anyone shade a light to theis problem?

I have columns C and H in a spreasheet that have date validation
format of mm/dd/yr.

Can you provide more detail on what you have/did/mean by "date validation
format"?

Rick

Hi Rick
I am restricting the start and end dates that can be input in these columns
so I used date validation. I used excel's Data Validation tool as follows:

Setting:
Date

Allow:
between

Start Date:
10/01/2007

End Date:
10/31/2007



"Rick Rothstein (MVP - VB)" wrote:

I have columns C and H in a spreasheet that have date validation
format of mm/dd/yr.

Can you provide more detail on what you have/did/mean by "date validation
format"?

Rick

I don't know if it will make a difference internationally, but try setting
up your start and end dates like this...

Start Date:
=DATE(2007,10,1)

End Date:
=DATE(2007,10,31)

instead of using text strings and see if that works.

Rick


"LM" wrote in message
...

Hi Rick
I am restricting the start and end dates that can be input in these
columns
so I used date validation. I used excel's Data Validation tool as follows:

Setting:
Date

Allow:
between

Start Date:
10/01/2007

End Date:
10/31/2007



"Rick Rothstein (MVP - VB)" wrote:

I have columns C and H in a spreasheet that have date validation
format of mm/dd/yr.

Can you provide more detail on what you have/did/mean by "date validation
format"?

Rick