K Posted September 3, 2020 Share Posted September 3, 2020 Hi, I tried to use excel pivot table with exported receipt data. But, the date format of the exported data is not consistent. I exported 8/31/2020 and 9/1/2020. Then the date of the 8/31/2020 shows as a text format such as 31/08/2020 09:00 but 9/1/2020 shows as 1/9/2020 09:00 and it shows as date format. So If I tried to converse the date/time to date format I should converse separately. How can I fix this problem? Thanks in advance. I attached screen shot. Link to comment Share on other sites More sharing options...
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now