If you want to format a date to a specific date format, like dd-MM-YYYY in Microsoft Excel VBA, use:

Dim specificFormatedString as String
specificFormatedString = Format(Date,"DD-MM-YYYY")

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.