| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Guru's,
I am racking my brain again with another date related issue. Hoping you can smack some sense into me.  )My worksheet data looks like this: (comma seperated) Start Date,End Date,Message 12/1/2007,12/31/2007,=a2&" thru "&b2 1/1/2008,1/30/2008,=a3&" thru "&b3 The results in column c is as follows: Message 39417 thru 39447 39448 thru 39477 .... and I would like it to be like this instead: Message 12/1/2007 thru 12/31/2007 1/1/2008 thru 1/30/2008 Any help you can provide would be greatly appreciated. Thanks in advance, Scott |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Try this:
=TEXT(A2,"MM/DD/YYYY")&" thru "&TEXT(B2,"MM/DD/YYYY") Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "porter444" <(E-Mail Removed)> wrote in message news:CEBBEAD9-D27B-4B44-9F8E-(E-Mail Removed)... > Guru's, > > I am racking my brain again with another date related issue. Hoping you > can > smack some sense into me. )> > My worksheet data looks like this: (comma seperated) > > Start Date,End Date,Message > 12/1/2007,12/31/2007,=a2&" thru "&b2 > 1/1/2008,1/30/2008,=a3&" thru "&b3 > > The results in column c is as follows: > > Message > 39417 thru 39447 > 39448 thru 39477 > > ... and I would like it to be like this instead: > > Message > 12/1/2007 thru 12/31/2007 > 1/1/2008 thru 1/30/2008 > > Any help you can provide would be greatly appreciated. > > Thanks in advance, > > Scott |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word 2007 "Modified" date doesnt change. | KarenNYC | Microsoft Word New Users | 6 | 12th Feb 2009 10:52 AM |
| Word 2007 "Modified" date doesnt change | KarenNYC | Microsoft Word New Users | 0 | 11th Feb 2009 04:23 AM |
| Most difficult Outlook 2007 question "Search subfolders" | kelly.a.dennis@gmail.com | Microsoft Outlook | 1 | 24th Jun 2008 10:19 PM |
| Access 2007 -- Current Date Field causing "Enter Parameter Value"error | MarkT | Microsoft Access Reports | 1 | 15th May 2008 10:56 PM |
| In Word 2007, how do I access the "Insert Date" drop down list? | =?Utf-8?B?SWFu?= | Microsoft Word Document Management | 1 | 5th Jul 2007 03:24 AM |
