format date

M

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
 
S

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
 
M

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
 
S

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
 
M

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top