I have two worksheets where cell A3 in both sheets are dates formatted as d-mmm-yy, but when I copy A3 from one sheet where it shows up as 1-Aug-22 to the other sheet it shows up as 44774 which I realize is the numeric equivalent of 1-Aug-22. How can I correct that and have it show up as 1-Aug-22.
Edit: I closed and reopened the workbook and the problem was gone.
