formating data
 

After importing banking information in the format "20041126000001", I want
the end result to be of the format "mm/dd/yyyy". The first 8 digits will be
used for this, the remainder may be deleted.

Thank you for your help.

Hi
use the following formula in a helper column:
=--TEXT(--LEFT(A1,6),"0000-00-00"))
and format this cell as date

--
Regards
Frank Kabel
Frankfurt, Germany

"MLH" schrieb im Newsbeitrag
...
After importing banking information in the format "20041126000001", I
want
the end result to be of the format "mm/dd/yyyy". The first 8 digits
will be
used for this, the remainder may be deleted.

Thank you for your help.

Hopefully Jan 1 2005 will come in as 20050101XXXXXX, if not this won't
work:
First select the column with the dates, then do datatext to column,
select fixed width and click next, click between the last day digit
(your example after 6)
click next, select the right hand column with 000001 and click do not
import (skip), select the left hand column and under column data format
click Date and YMD
click finish Returns 11/26/2004 for me


Regards,

Peo Sjoblom