Date (dd/mmm/yyyy)

E

ernie

when i put in this code:

txtDate.value = Date

the output format is:

06/09/06 (mm/dd/yy)

how do i modify the code to get the results in this format:

06-Sep-2006 (dd/mmm/yyyy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Format - simple question 1
How to add day to PWA 2016 date format? 0
Date format. 2
Combobox date value matching 0
ComboBox value matching 0
International Date formatting 6
Vba Date$ 1

Top