Hi Anju,
There is no formula required. You need to understand the concept.
First follow these steps and see if you understand the problem or need
explanation.
1. Close all Excel applications.
2. Open "Regional and Language Options" from "Control Panel".
(Start --> Settings --> Control Panel --> Regional and Language
Options)
3. Under "Regional Options" tab, change "English (United States)" to
"English (United Kingdom)".
4. Click Ok.
This should resolve your problem.
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
On Oct 27, 2:26 pm, Anju <anjulav...@gmail.com> wrote:
> Hi ,
>
> Please help to format the dates in attached excel file to dd/mm/yyyy
> hh:mm:ss. when i treid formating the dates somedates format was dd/mm/yy
> hh:mm:ss...but i need as dd/mm/yyyy hh:mm:ss for all the dates.
>
> Thanks
>
> DateFormat.xlsx
> 538KViewDownload
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
