On Thu, 29 Sep 2005 08:52:03 -0700, "colin"
wrote:

I have a column of dates, they are in yyyymmdd format (no slashes or
anything) and they're text. I cannot format them, how do I do this?

Basically, I want to change 19700429 to 4/29/1970, but for a whole column of
different dates (dates not in sequential order).

Thanks in advance!!!!!

Two ways:

Select the column
Data/Text to Columns
Next
Next
Column Data Format/Date: YMD
Finish

--------------

or you can use a formula in a "helper" column

=--TEXT(A1,"0000\/00\/00")




--ron