formating data

M

MLH

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

Frank Kabel

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

Peo Sjoblom

Hopefully Jan 1 2005 will come in as 20050101XXXXXX, if not this won't
work:
First select the column with the dates, then do data>text 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
 
Top