在CentOS 5.6上安装cairo 1.8.6(Installing cairo 1.8.6 on CentOS 5.6)

 这应该很容易。 您需要做的就是使用相同的范围并更改单元格的数字格式。 请注意：粘贴的值不变（数组中的值应为日期）。 Excel应用格式，以便更改显示的内容，但不会丢失基础信息。 
 
 如果您的数组中充满了字符串，您需要预先将它们转换为日期。 Excel可以隐式执行此操作（例如，它可以自动格式化它们，尽管原始值是日期），但显式转换是首选。 
 
 对于您的代码，请使用： 
 
With .Range("D2").Resize(UBound(vef, 1), 1)
    .Value = vef
    .Numberformat = "dd.mm.yyyy hh:mm:ss"
End With
 
 最后，我只想指出你的Ubound(vef, 1)只有在你的数组基于1时才有效。 如果它基于0，则调整大小的范围将偏离1.可用于查找数组中维度长度的公式为： 
 
Length = (Ubound(Array, DimensionNumber) - LBound(Array, DimensionNumber)) + 1
 
 所以在你的情况下： 
 
Length = (Ubound(vef, 1) - LBound(vef, 1)) + 1
 
 祝你好运！ 

That should be easy enough. All you need to do is work with the same range and change the numberformat of the cells. Please note: the value being pasted is unchanged (and the values in your array should be dates). Excel applies a formatting so that what is displayed is changed, but without losing the underlying information.
 
If your array is full of strings, you will want to look at converting them to Dates beforehand. Excel may do this implicitly (e.g it may automatically format them, despite the original values being dates), but explicit conversion is preferred.
 
For your code, use this:
 
With .Range("D2").Resize(UBound(vef, 1), 1)
    .Value = vef
    .Numberformat = "dd.mm.yyyy hh:mm:ss"
End With
 
Finally, I would just point out that your Ubound(vef, 1) will only work if your array is 1 based. If it is 0 based, your resized range will be off by 1. The formula you can use to find the length of a dimension in an array is:
 
Length = (Ubound(Array, DimensionNumber) - LBound(Array, DimensionNumber)) + 1
 
So in your case:
 
Length = (Ubound(vef, 1) - LBound(vef, 1)) + 1
 
Good luck!