Printable View
I download the calandar from the net free
http://www.wincalendar.com/calendar-maker.html
Suppose the user selects the dats 16-May-2010 ,then in cell the value is 5/16/2010 because excel by default format is DMY. Can we chnage this format,I wnat that when the user selects the date 16-May-2010 ,Then I want that in cell value to be 16/5/2010. Is it possible?? How to do that??
format the cells as date in the required format
Many ways you can do it...
1) Like Pete mentioned, Format the cells by right clicking on it and select 'Format Cells'. Under Number "Tab", select Custom and in 'Type' type d/m/yyyy. Click Ok.
OR
2) Change the regional settings of your computer by clicking on Control Panel. See this link on how to do it.
you can also change the cell formatting by code
range("c:c").numberformat = "dd/mm/yyyy"