阅读背景:

格式为“YYYY MMM DD 00:00:00.000”的Excel日期需要日期为DD-MMM-YYYY

来源:互联网 

Is there a way to program a macro to convert all dates in a worksheet to go from "2009 APR 01 00:00:00.000" to a date format "dd-mmm-yyyy"? I have a data set that is regularly pulled and all the dates in 40+ columns are basically useless in 2009 APR 01 00:00:00.000, any ideas on how to create this type of macro and be able to share with others using the same data?Is there a way to program a macro to convert al




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: