Hi,
Forst Select your dat then go to format in the Home Menu(if your using Excel 2007) or format if you are using older versions.In the format menus dialog box you can select date formats as you like.At the last the is Customs format. If you select that and specify what ever type of format you want(i.e dd/mm/yyyy hh.mm.ss or anything else).Only in Custom format you can customize and specify the format you like your text to be in. You can also use formulas for changing the format as specified below by our friend. Regards, VIJAY KUMAR -- ---------------------------------------------------------------------------------- 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