把这句
str2 = UCase(arr(i, 1) & "#" & arr(i, 2) & "#" & arr(i, 3) & "#" & arr(i, 4) & "#" & arr(i, 5) & "#" & arr(i, 7))
改为
str2 = UCase(arr(i, 1) & "#" & arr(i, 2) & "#" & arr(i, 3) & "#" & arr(i, 4) & "#" & arr(i, 5) & "#" & Format(arr(i, 7), "0.00"))
|