hope someone can help!
希望有人可以帮助!
I have an Excel 2010 worksheet which has macros set up to copy data from other sheets into a specific format on another sheet for use with other processes. The data I need copies over ok but I have an issue with the formatting of cell ranges which hold date or time values. The data originates from a database extract and everything is in text format. In my worksheet when I copy the date in (via VBA code procedures) I apply the format we require, which is I have an