Date Format
in [General]
|
Prev: How do I view complete text content in an Excel Comment box?
Next: Converting irregular Word table to spreadsheet
From: Graham on 25 Apr 2010 07:43 I have dates shown as: A B C 2010 5 Mar I need them to change to 1 cell in the format 05/03/2010 Can anyone help?? ThanKS Graham
From: Roger Govier on 25 Apr 2010 08:09 Hi Graham One way =--(B1&"/"&C1&"/"&A1) -- Regards Roger Govier Graham wrote: > I have dates shown as: > > A B C > > 2010 5 Mar > > I need them to change to 1 cell in the format 05/03/2010 > > Can anyone help?? > ThanKS > Graham
From: joel on 25 Apr 2010 08:07 I put this formula in column D2. Then format column D in a Date format otherwise you will get a number like 40242 =DATEVALUE(C2&" "&B2&", "&A2) -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=198299 http://www.thecodecage.com/forumz
From: Teethless mama on 25 Apr 2010 11:58 =DATE(A1,MONTH(C1&1),B1) "Graham" wrote: > I have dates shown as: > > A B C > > 2010 5 Mar > > I need them to change to 1 cell in the format 05/03/2010 > > Can anyone help?? > ThanKS > Graham
From: Teethless mama on 25 Apr 2010 12:01
Another... =--(C1&B1&", "&A1) "Graham" wrote: > I have dates shown as: > > A B C > > 2010 5 Mar > > I need them to change to 1 cell in the format 05/03/2010 > > Can anyone help?? > ThanKS > Graham |