Use this =CONCATENATE(D8," ",D9," ",TEXT(D10,"dd-mmm-yy"))
where D8 = MS D9= Excel D10 = 24 - Oct - 08 u will get the answer. On Fri, Oct 24, 2008 at 7:04 AM, [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, Gyanesh Jain +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really need to --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---