replace the . with / With Range("C3") .Value = DateValue(Replace(.Value, ".", "/")) .NumberFormat = "mm/dd/yyyy" End With.
確定! 回上一頁