Results 1 to 2 of 2

Thread: Changing the date format

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte reagancennon's Avatar
    Join Date
    Feb 2019
    Posts
    1
    Articles
    0
    Excel Version
    1901

    Changing the date format

    Hi there, I was sent a CSV file containing sales information for a client of mine however once opened in excel the date was incorrect; it is reading the month correctly but switched the day and year. I've attached a screen shot of what it looks like. I am wondering if/how i can change this?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Excel Dates.PNG 
Views:	8 
Size:	5.1 KB 
ID:	8887  

Tags for this Thread

Posting Permissions

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