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.
|