| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format date
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format date
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format date
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 - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format date
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 - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format date
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 On Apr 9, 10:09*am, 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 -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
