Hi Gyanesh, Thanks so much .... Its working fine... :)
Cheers Shyam 2008/10/24 gyanesh jain <[EMAIL PROTECTED]> > 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 -~----------~----~----~----~------~----~------~--~---
