leading zero date

  1. S

    Remove leading zeros from dates in mm/dd/yyyy format (so they can sort chronologically)

    Hi, I export a report from SAP to Excel which generates leading zeros in the format mm/dd/yyyy, which Excel doesn't seem to recognize as dates. I changed the Format from whatever the query generated to Date format, so that the filter lists the dates chronologically. But the Sort function...

Some videos you may like

This Week's Hot Topics