Date (dd/mmm/yyyy)

G

Guest

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

Date format. 1
Copy Range to new Range and keep DATE format?? 26
Excel is changing date format incorrectly 7
Another Question about Date Formatting 2
Simplify save code 11
Vba Date$ 1
date format in user form 1
VBA in Excel 2007 date formatting 2

Top