Hi,

in a helper column ( empty column) enter this formula ( asumed your original
column is A)

=LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,4)

copy drag down the formula to your 1500 line
copy paste especial value your helper column to youe original column
delete helper column

Thanks,

--
Farhad Hodjat


"Junderwood57" wrote:

I'm creating a very large spreadsheet and have a question, with hopefully a
simple solution. The dates that pulled into Exel are formatted as 20070529.
There are over 1500 lines with dates this way and all different dates. How
do I chnage these dates to format as a regular 05/07/2007? the format cell
function does not work and to manually change would take quite a while. I'm
not sure if there is a way to paste special? Anyone's help would be
appreciated.
Thanks!