Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

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

Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

try this: =TEXT(C3; dd/mm/ hh:mm:ss) On Wed, Oct 27, 2010 at 4:26 PM, Anju anjulav...@gmail.com wrote: Hi , Please help to format the dates in attached excel file to dd/mm/ hh:mm:ss. when i treid formating the dates somedates format was dd/mm/yy hh:mm:ss...but i need as dd/mm/

Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

This is new for me. Thanks, On Wed, Oct 27, 2010 at 3:53 PM, ratu elissa masihgadis...@gmail.comwrote: try this: =TEXT(C3; dd/mm/ hh:mm:ss) On Wed, Oct 27, 2010 at 4:26 PM, Anju anjulav...@gmail.com wrote: Hi , Please help to format the dates in attached excel file to dd/mm/