Results 1 to 6 of 6

Thread: How change date format.

  1. #1

    How change date format.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How do I change 01.11.2011 to 201145 (see the year and week).

  2. #2
    you have two choices:
    1. You have to check in which format the Date is defined in your Excel (i.e. {mm/dd/yyyy} or {mm.dd.yyyy} etc. ), you can do that by checking the cell format. so if its defined like this mm/dd/yyyy you need to change your date to 01/11/2011.
    After you did that and wrote it in the cell, change the cell TYPE to "General".

    2. If you want to keep your date in this format
    {mm.dd.yyyy} as you write it, then you have to change how the date is defined in your excel (again go to cell format and choose the desired templete in our case {mm.dd.yyyy}.
    After you did that and wrote it in the cell, change the cell TYPE to "General".

    Hope you understand and it works


  3. #3
    Hi ovega

    Assuming the data is A1,
    Opt 1: =YEAR(A1)&WEEKNUM(A1)
    Opt 2: =(YEAR(A1)&WEEKNUM(A1))+0

    Opt = text value
    Opt = Number

    Kevin

  4. #4
    You can use

    =YEAR(A2)*100+WEEKNUM(A2)

  5. #5
    Hi Kevin

    Thanks for your help, it works well for me.
    What means +0 in your formula ?

    Ovega

  6. #6
    Hi Ovega

    It is to coerce the text value to a number.

    Kevin

Posting Permissions

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