Alright, this time I made a file so you guys can see what I want to achieve: https://onedrive.live.com/redir?resi...154C70!12160 So there are two tabs in this workbook. On the "Good" tab, the dates are converted to the first of the month. So for instance, 3/13/14 on the "Date" column will be 3/01/14 on the "MM/YY" column. On the "Bad" tab however, the "MM/YY" looks the same as in the "Good" tab but still retains the same date value as in "Date" column. SO for instance, 3/13/14 on "date" is still 3/13/14 on "MM/YY". The MM/YY on the "good" tab is the result I want. I did it once...remember it involved pasting to a clipboard but forgot how to do it again. Can anyone enlighten me? thank you.