Thread: [Solved] Date Format for days 01-12 are americanized
View Single Post
 
Old 09-06-2015, 09:32 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
see if either of these work
Code:
.Cells(lRow, 1).Value = Format(Me.pDate.Value, "Short Date")

.Cells(lRow, 1).Value = Me.pDate.Text
Reply With Quote