qqp question1: In 2010 I have a column that is a date in MM/DD/YYYY format and I want to switch it to MM/YYYY format so when I use it in a pivot table it doesn't list each specific date separately in Excel 2010. How do I do this? question2: How can you use time formats in Excel?