VBA中如何把excle中提取的字符串20090405变成日期型2009/4/5

Question

如题所述

Answer 1

Dim a As String, b As Date
a = "20090405"
b = DateSerial(Left(a, 4), Mid(a, 5, 2), Right(a, 2))

Answer 2

=LEFT(A1,4)&"/"&(MID(A1,5,2)+0)&"/"&(RIGHT(A1,2)+0)

Answer 3

在格式里直接改应该就可以