ExcelBanter - Date (dd/mmm/yyyy)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date (dd/mmm/yyyy) (https://www.excelbanter.com/excel-programming/372298-date-dd-mmm-yyyy.html)

Ernie

Date (dd/mmm/yyyy)

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)

Gary''s Student

Date (dd/mmm/yyyy)

txtDate.value = Format(Date, "dd-mmm-yyyy")
--
Gary's Student

"ernie" wrote:

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)

All times are GMT +1. The time now is 08:37 AM.