Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Date format conversion...

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to convert date from a European format (yy/mm/dd) to mm/dd/yyyy format used in the US? I have a spreadsheet that was created on a computer with Regional Settings configured as the UK.

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-27 13:22, misio wrote:
    Is there a way to convert date from a European format (yy/mm/dd) to mm/dd/yyyy format used in the US? I have a spreadsheet that was created on a computer with Regional Settings configured as the UK.

    Thanks
    Hi misio:
    Of course! The numbers behind the dates don't change -- just the format changess
    So select the date cell then FORMAT|CELLS|NUMBER|Date ... then look at all the options you have for formatting!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Wellington
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Assuming the date you want to convert is in cell A1, and the format of that date is 'yy/mm/dd', and also your computer's regional setting is US, ie your date would be mm/dd/yy.

    Then, the following formula might help you:
    =date(left(a1,2),mid(a1,4,2),right(a1,2))

    The above date is formula is based on =date(year,month,date), so you can adjust the length of your substring.

    HTH

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
  •