-
Sep 30th, 2022, 09:33 AM
#1
[RESOLVED] Strange Copy Problem
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.
Last edited by MartinLiss; Sep 30th, 2022 at 09:37 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|