Results 1 to 1 of 1

Thread: [RESOLVED] Strange Copy Problem

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Resolved [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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width