Prevent User changing date format

[thong127]

Hello everyone,

How can I prevent a user not to change the date format in excel?

Thank you?

thong

[Richard Buttrey]

Hi,

Set the cell protection to locked and protect the worksheet perhaps?

[thong127]

Hi Richard,

Thank you for the quick reply. I cant protect the worksheet because they will be entering the dates. but some users entered in different format.

[Richard Buttrey]

Hi,

Can't you use data validation to control the date entered?

[thong127]

Hi Richard,

Where can I find data validation?

Thanks.