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 9871809605 www.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 -~----------~----~----~----~------~----~------~--~---
