I download data from a url site and the date shows as Jan 21 but when I look at cell contents it is 1/21/2020 which is incorrect. what is a simple formula to correct this to 1/20/2021?
I have quite a few lines to do this with and three sheets. I do this every day. Too much to change manually.
There is also another hickup in the download, every JULY date downloads as a text "JLY 21" and must be changed to 21-Jul, mmm-dd to yy-mmm. Any help is greatly appreciated, thanks in advance.
I have quite a few lines to do this with and three sheets. I do this every day. Too much to change manually.
There is also another hickup in the download, every JULY date downloads as a text "JLY 21" and must be changed to 21-Jul, mmm-dd to yy-mmm. Any help is greatly appreciated, thanks in advance.