Hi, the default date format in Excel is driven by the regional and language
settings in control panel on each machin. If you do not like the default
change it here by hitting the customize button next to the region you select.
then click on the Date tab, you can now set out the date format you wish for
and this will be picked up by Excel.

Hope you understand this.

"muddan madhu" wrote:

i am not able to.....

i need date format as dd-mmm-yyyy

only some numbers are formatted,

eg - before format after format
01/01/2008 01-jan-2008
10/01/2008 10-jan-2008
01/13/2008 01/13/2008 but it should be 13-
jan-2008



On Apr 9, 1:52 pm, "Sandy Mann" wrote:
Dates are just numbers so highlight all the dates andformat the cells to the
date format that you want.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"muddan madhu" wrote in message

...



hi all,

I have excel file where user updated date in different format..
How can i make to one common formar say dd/mm/yyyy.

Eg., 01/01/2008 -means 1st jan,2008
01/10/2008 -means 10th jan,2008
11/1/2008 - means 1st Oct,2008

I think u got it .... what i am trying to say....

some user updated dd/mm/yyyy and some as mm/dd/yyyy......

Thanks- Hide quoted text -

- Show quoted text -