How about Formatting it as 0000-00-00
??

"spreadsheet monkey" wrote:

I am trying to convert a column of dates that come in the format "20071101"
into
"2007-11-01" in an automated fashion (if possible in a formula since I will
include it in another one)

problem, the data is imported which means that is comes in "general" format
and needs to be in either "text" or "number" format for me to use any of the
functions like VALUE... how can I change to entire coulmn with a function so
that it converts the data to correct format? (without using TEXT TO COLUMS)

thx