I have read all what is in the "Help" directory. I have a col of dates given in "CCYYMMDD" format and I want to insert a "/" between the year month and day but am only getting a whole row of "#####"'s. How do I get the date of 20021116 to read 2002/11/16 and format it all the way down the column. Sounds simple enough but I just cannot get it to work.