software

I have been trying to format a serial date to the format yyyy/mm/dd 00;00 am
An example of the text is 200501090932. The time is in military time. I have
tried the text ot columns but my string is too long. Any help will be greatly
appreciated.

The serial date in EXCEL for the string you gave is 38361.40.

I converted it using the following equation
=DATE(LEFT(A1,4),MONTH(MID(A1,5,2)),DAY(MID(A1,7,2 ))) TIME(MID(A1,9,2),MID(A1,11,2),)

where A1 contained the value 200501090932.
quot;Cedricquot; gt; wrote in message
...
gt;I have been trying to format a serial date to the format yyyy/mm/dd 00;00
gt;am
gt; An example of the text is 200501090932. The time is in military time. I
gt; have
gt; tried the text ot columns but my string is too long. Any help will be
gt; greatly
gt; appreciated.
Another way

=--TEXT(TEXT(LEFT(A1,8),quot;0000\-00\-00quot;),quot;dd/mm/yyyyquot;)--TEXT(TEXT(RIGHT(A1,4)
,quot;00\:00quot;),quot;hh:mmquot;)

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Barb Reinhardtquot; gt; wrote in message
...
gt; The serial date in EXCEL for the string you gave is 38361.40.
gt;
gt; I converted it using the following equation
gt;
=DATE(LEFT(A1,4),MONTH(MID(A1,5,2)),DAY(MID(A1,7,2 ))) TIME(MID(A1,9,2),MID(A
1,11,2),)
gt;
gt; where A1 contained the value 200501090932.
gt;
gt;
gt;
gt; quot;Cedricquot; gt; wrote in message
gt; ...
gt; gt;I have been trying to format a serial date to the format yyyy/mm/dd 00;00
gt; gt;am
gt; gt; An example of the text is 200501090932. The time is in military time. I
gt; gt; have
gt; gt; tried the text ot columns but my string is too long. Any help will be
gt; gt; greatly
gt; gt; appreciated.
gt;
gt;