|I think I am doing something wrong.....Here is what I have done, step by step:|
1. I broke down my spreadsheet and I have all of the dates already popluted in Column C with the first one in cell C2 as "1/12/2011" all the way down to cell C436 as "9/30/2010".
2. I opened inserted a blank column to the right in column D. I started with the first cell directly to the right, cell D2 and entered "=DATEVALUE(C2)" and dragged it all the way down to cell D436; i.e. making cell D235 read "=DATEVALUE(C235)"
3. As soon as I hit enter, the cells all change to read "#VALUE!"
4. Not knowing if this is because there was no value in the cell or not, I pressed forward and formatted the column and then did the paste special.
I think I am doing something wrong in step 2, but not quite sure what it is.
Thanks for your patience and your guidance; I am not an excel expert by no means.