- Nov 30, 2005
- 1,059
- 1
- 81
Alright, this time I made a file so you guys can see what I want to achieve:
https://onedrive.live.com/redir?resid=E18117CDA154C70!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.
https://onedrive.live.com/redir?resid=E18117CDA154C70!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.