Reformat the date and time picker

[imran91]

Hi guys

How should i reformat the date and time picker? at this moments, it shows the date in the format of mm/dd/yyyy but the format that i want is dd/mm/yyyy. So, anyone can help me?

Thank you.

[dogberry]

Hi

Havent used it can you not use data validation to change cell contents having selected your date.


Chris

[imran91]

Hi Chris. Thank you for quick reply, but i dont get it. can u explain more?

[dogberry]

Hi

As I said never used the date picker. However if you go into data validation you can enter your dates between 1/jan/1900 to 31/jan/2525 or what ever suits then any date entered in selected range should change to correct format for what you want.

Chris

[Toonies]

Hi check this out


http://msdn.microsoft.com/en-us/libr...=vs.60%29.aspx

[dogberry]

Hi

Forgot to mention to format your cells for the date format that you want.

Chris

[imran91]

owh ok i get it. I can't used the data validation. I should use some kinds of calendar for my system and so far, date picker are the easiest but it have problems in the formatting.

[dogberry]

Hi

My workaround should do the job. If not having a quick read of Toonies link it would appear that you can use it but the VBA code for it needs altering to match your date format, perhaps if you upload a sample sheet one of our VBA experts can alter it for you.

Good luck


Chris

[Toonies]

Are you wanting to place a date in 1 cell or a range?

[john55]

as an option you can use a calendar...
http://www.excelforum.com/excel-prog...textboxes.html

[imran91]

yes. from the date picker, i link a cell to it. I already format the linked cell to the format that i want but still cant work.