|
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 |
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 |
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 - |
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 - |
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 - |
| All times are GMT +1. The time now is 06:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com