Hi this works well. How to concotenat the time formate for eg: MS Exce 12:15 AM how to do this..
Regrds, vinu. On Oct 29, 9:18 am, "Bhavish Poddar" <[EMAIL PROTECTED]> wrote: > Hi use this function : =A1&" "&B1&" "&TEXT(C1,"dd-mmm-yy") > where A1 = MS > B1 = Excel > C1 = 29-0ct-08 > > On Fri, Oct 24, 2008 at 11:31 AM, H Upadhyay <[EMAIL PROTECTED]>wrote: > > > > > Pls chk attached file > > > Regards > > Harish Upadhyay > > > On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > >> Hi All, > > >> I have an issue while using concatenate formula, Can any one of you help > >> me out with this: > > >> Query: > > >> Column A : MS > >> Column B : Excel > >> Column C : 24- Oct-08 ( formated as d-mmm-yy). > > >> When I use concatenate i get a result as : MS Excel 39745 > > >> After formatting the cell too d-mmm-yy, I get the same result instead of > >> MS Excel 24-Oct-08. > > >> Please advice me if there is any other way out to get the result as > >> desired. > > >> Thanks in Advance > > >> Cheers > >> Shyam > > -- > Thanks and Regards, > > Bhavish Kumar Poddar > Sr. Executive - Business and Process Analytics > > V5 Global Services Pvt. Ltd > 203-206, 2nd Floor, Skipper House, > 62-63, Nehru Place, New Delhi-110019 > T: +91 11 4651 5500 > D: +91 11 6662 0396 > F: +91 11 2623 2329 > M: +91 9871809605www.v5global.com| [EMAIL PROTECTED] | skype: bhavishp --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
