Hi all,
I have encountered an issue where the Excel not recognizing the dates as dates, I tried to .NumberFormat = "dd/m/yyyy;@" for the whole range but this does not do the job.
If I was to do it manually, a solution is to edit the cell and click enter.
Any thoughts on the solution? Thank you
I have encountered an issue where the Excel not recognizing the dates as dates, I tried to .NumberFormat = "dd/m/yyyy;@" for the whole range but this does not do the job.
If I was to do it manually, a solution is to edit the cell and click enter.
Any thoughts on the solution? Thank you
Book3 | ||||
---|---|---|---|---|
A | B | |||
1 | Now | Need | ||
2 | 14/9/2020 | 14/9/2020 | ||
3 | 14/12/2020 | 14/12/2020 | ||
4 | 14/12/2020 | 14/12/2020 | ||
5 | 14/12/2020 | 14/12/2020 | ||
6 | 03/12/2021 | 03/12/2021 | ||
7 | 03/12/2021 | 03/12/2021 | ||
Sheet1 |