software

How can I convert a string as 08-MAR-06 to a date in an excel cell?
right click on mouse
select format cells
select numbers tab
select date
select the format you want--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=517994I am sorry I did not make myself clear in the first post.

My cell's formular is
=CONCATENATE(MID(B3,6,2),quot;-quot;,MID(B3,1,3),quot;-quot;,MID(B3,10,2)), which is equal to
08-Mar-06, but it is a string. How can I make it to a date in the cell?

Thanks.

quot;davesexcelquot; wrote:

gt;
gt; right click on mouse
gt; select format cells
gt; select numbers tab
gt; select date
gt; select the format you want
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=517994
gt;
gt;


Multiply your formula by 1.

=CONCATENATE(MID(B3,6,2),quot;-quot;,MID(B3,1,3),quot;-quot;,MID(B3,10,2))*1

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=517994NICE. Thanks.

quot;SteveGquot; wrote:

gt;
gt; Multiply your formula by 1.
gt;
gt; =CONCATENATE(MID(B3,6,2),quot;-quot;,MID(B3,1,3),quot;-quot;,MID(B3,10,2))*1
gt;
gt; HTH
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=517994
gt;
gt;


No problem.--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=517994