format date

[muddan madhu]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[muddan madhu]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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

 

[Millies Dad]

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.

 

[Pete_UK]

Perhaps those "dates" that do not change are really text values that
happen to look like dates. Select an empty cell and click <copy>, then
highlight all the dates and click on Edit | Paste Special | Values
(check) | Add (check) | OK and then <Esc> - this should convert all of
them to numbers, which you can then reformat as dates.

Hope this helps.

Pete