Re: $$Excel-Macros$$ Date to be formatted in to Customised Format

Thanks a Ton Master :-) Working fine !! have a gud day! JP. On Tue, Jul 17, 2012 at 11:03 AM, NOORAIN ANSARI wrote: > Dear JP, > > Please use below formula for desired output. > > =CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM")) > > or > > =TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm

Re: $$Excel-Macros$$ Date to be formatted in to Customised Format

Dear JP, Please use below formula for desired output. *=CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM"))* or *=TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm:ss AM/PM") *See attached sheet for reference.* * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.bl

$$Excel-Macros$$ Date to be formatted in to Customised Format

Dear Experts, Good Morning... Need your Help in formatting the Given Date in to customised format per attachment... Thanks in Advance! JP. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne