Record the Date without the Time

103
0
01-07-2019 10:21 AM
by Anonymous User
Not applicable

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?

Tags (2)
0 Kudos
0 Replies