You should nevertheless be able to re-format the cells. As I said, Dates
are just numbers - Re-format any *Date" as General and you will see the
underlying number in the cell. The *formatting is just a mask XL places
over the number to make it look like a date for humans.

Select all the dates that you want to change then select Format cells
Custom and then type in youself dd-mmm-yyyy in the Type box.

--
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
...
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 -