When recording the Date, there is a default for time. This is creating havoc when I try to create a Pivot Table from a converted excel file. I need to be able to sort by date and the added time is messing everything up? is there a way to only collect the Date and not have the Time option? or in excel eliminate the Time? every Format Cell option keeps the time in the background?
