6,216
社区成员




=year(K10)
如果是以文本来储存日期的就是
=left(K10,4)
Sub ChangeToY()
Dim nRow As Integer
nRow = ActiveSheet.Range("K65536").End(xlUp).Row
For i = 1 To nRow
If Cells(i, 11).NumberFormat = "m/d/yyyy" Then
Cells(i, 11) = "Y"
End If
Next
End Sub