Datatext to columns, click next twice, under column data format select date
and YMD,
click finish
for a formula solution assuming they always have 8 digits
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
--
Regards,
Peo Sjoblom
"Josh O." wrote in message
...
I have a date field that I need to convert into a usable date format.
The current date is input into a field as yyyymmdd. But the number is
entered as text. Is there a way to format that number or a formula to use
to
make that format usable? What I want to use the date for is to create a
formula that calculates the days past due. For example, =("invoice
date"+30)-today( ).
However the formula won't work with the date in its current format.
|