I'm sorry, I copied, then used Paste Special Values, I put a 1 into a random empty cell, copied that cell, then selected the date range and clicked Paste Special and selected Values and Multiply. I either got a column of nonsense (41000, 41001, 41001, 41001, 41002, 41003, 41003 ect...) or a column of zeros.

Is there something I did wrong there or something I am missing? And do I paste next to the column I used the first Paste Special Values in or do I paste over that first Paste Special Values? When I pasted next to it, all I received were 0's, when I pasted over the first Paste Special Values I received the 41000, 41001 ect.