I created a weekday column which displays Mon, Tue, Wed, etc. for example, May 05 2018 which appears as Sat in my weekday column actually contains an alphanumeric code behind it (1900-01-07). copy and paste values is not allowing me to erase this alpha numeric code in the back ground and I cannot create the pivot table I need. I simply need to summarize some data by weekday. please help!
Solved by V. J. in 15 mins