Microsoft Office Forums - View Single Post - [Solved] Date Format for days 01-12 are americanized

Thread: [Solved] Date Format for days 01-12 are americanized

View Single Post

Old

09-07-2015, 06:49 PM

jcrennan

jcrennan is offline

jcrennan uses Windows 7 64bit

Windows 7 64bit jcrennan uses Office 2010 64bit

jcrennan uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Sep 2015

Posts: 5

jcrennan is on a distinguished road

Default

Thanks

Quote:

Originally Posted by NoSparks

View Post

see if either of these work

Code:

.Cells(lRow, 1).Value = Format(Me.pDate.Value, "Short Date")
 
.Cells(lRow, 1).Value = Me.pDate.Text

I tried these but no luck

Reply With Quote