I have a column of dates that I'm trying to get into the format yearmonthday only I don't want any characters or spaces between them, just values like this 20090418. Right now it looks like this: 3/1/2007 3/2/2007 3/5/2007 3/6/2007 3/7/2007 3/8/2007 I can get it switched so it's year/month/day but I can't seem to get rid of the /'s. I've tried a couple of things like copying the column and just pasting the values but that doesn't work. Any ideas? Also it's not every day of the year, it excludes weekends and holidays. Thanks!