Date format conversion...
VBA Telemetry pings you when your VBA projects fail
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

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
  •  

 

 
DMCA.com