Trying to use an Excel Date and Time function, but Excel returns a serial number instead of date; this is because Excel stores dates and times in serial numbers in the backend; for instance, when you ...

In a previous tip I explained how to display numbers with leading zeros. I also explained in another tip how to format numbers with a leading zero. Here I am going to explain how to display that ...