Results 1 to 2 of 2

Thread: Data Formatting
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2011
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Formatting

    Dear All,

    I need to write date in dd/mm/yyyy format only. But I receive data mainly in mm/dd/yy format and sometimes in mm/dd/yyyy format.

    Pls help me.

    Thanks in advance.

  2. #2
    Legend VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Data Formatting

    Select a column of dates, Data > Text to Columns, click Next twice, tick Date and select MDY then click Finish.
    HTH, Peter
    Please test any code on a copy of your workbook.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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