I have an XL sheet with data in the format "07/07/2005 10:00:00". I need it
in the format "07/07/2005 10:00", so that I can create a pivot table with
the date and count of some records. How do I make the date in this format.
Tried the formatting, but it works incorrectly in the pivot table. Pls help...