the day/month order is a windows setting:
Start / Settings / Control Panel / Regional and Language Options,
either change your location, or click Customize, and Date


"jckumar" wrote:

if i change this format 07/03/2009 to some other format through right click,
and format cells - date - 07-mar-2009 but the change will be happen to this
format July/03/009. But i wnt only on this format dd/mm/yy

thanks for helping me.