Dear Shyam, Below is the formula for your query
*=CONCATENATE(A1&B1&""&TEXT(C1,"dd-mmm-yy"))* regards, siva On 10/24/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 > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---