• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Format csv Date to Date dd-mmmm-yyyy

AV114

Member
Hello

I'm importing every day with a csv file containing dates. I'm looking for a macro or other ideas to change data format to dd-mmmm-yyyy and save it

and opening the same csv file the date should be show as dd-mmmm-yyyy

From
11-27-2018

To
27-November-2018
Is this possible ?
100.gif


Thanks for your help
 

Attachments

  • Book3.csv
    163 bytes · Views: 4
The text file has 27 November 2018
Excel will import that using dd-mmmm-yyyy format

But how it displays it is based on your system default settings

Simply select the dates,
Right Click and Format Cells
Select Number Format, Custom and use a Custom Number format of : dd-mmmm-yyyy
 
Back
Top