Hi, Pls gohead with this attachment............. WISH U HAPPY DIWALI
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Thu, 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Concatenate Formula
To: excel-macros@googlegroups.com
Date: Thursday, October 23, 2008, 8:34 PM
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
-~----------~----~----~----~------~----~------~--~---
Book2.xls
Description: MS-Excel spreadsheet
