Hi can anyone help me with my problem,
I'm trying to insert a value from another wb to another wb using macro. The source date is 1/7/2021 but when the macro insert the value in another wb the date changes to 7/1/2021. How to prevent the cell value to change its date format?
The data type for the date in the source file is "Short Date"
Thanks and regards,
Shumai
I'm trying to insert a value from another wb to another wb using macro. The source date is 1/7/2021 but when the macro insert the value in another wb the date changes to 7/1/2021. How to prevent the cell value to change its date format?
The data type for the date in the source file is "Short Date"
Thanks and regards,
Shumai