Ok...I will try to explain this as well as I can...I have a spreadsheet that has columns with dates in them. When you look at the spreadsheet, all you see is the date. However, the person who created the spreadsheet also entered times in the cells, but you only see the time when you click on each individual cell. How do I get rid of that? I want to see only the date when I look at the spreadsheet AND when I click on each individual cell. My format for these cells is the first option under FORMAT CELLS, NUMBER (tab), DATE. PLEASE HELP!!!