Range("A1:AA1000").Activate
Range("A1:AA1000").NumberFormat = "G/通用格式"
Range("A1:AA1000").Value = Range("A1:AA1000").Value
Range("A1:AA1000").NumberFormat = "0.00"
Range("A1:AA1000").Value = Range("A1:AA1000").Value
Range("A1:AA1000").Activate
Range("A1:AA1000").NumberFormat = "G/通用格式"
Range("A1:AA1000").Value = Range("A1:AA1000").Value
Range("A1:AA1000").NumberFormat = "0.00"
Range("A1:AA1000").Value = Range("A1:AA1000").Value
本文标题:宏代码--更改用友U8导出数据中数字格式为0.00
本文链接:https://www.haomeiwen.com/subject/uewosftx.html
网友评论