Change existing data from Date & Time to just Date
Posted by Paul Magruder on May 16, 2001 10:30 AM
I have 1500 rows of data that was returned using =Now().The problem is I need the Pivot table to Pivot the data, Just recognizing the "date" and ignoring the time. It currently looks for both, and is only returning 1 data point(because of the time).
Thanks in Advance
Paul