Help with 2018 spreadsheet

Discussion in 'Lantus / Levemir / Biosimilars' started by Andreea&Tilica, Jan 3, 2018.

Thread Status:
Not open for further replies.
  1. Andreea&Tilica

    Andreea&Tilica Member

    Joined:
    Jan 25, 2017
    Hi,

    Can anybody help me to set the date on the spreadsheet for 2018? I would like to set the date the same as 2017 spreadsheet but I fail.:(
     
  2. Mandy & Rex (GA)

    Mandy & Rex (GA) Well-Known Member

    Joined:
    Mar 22, 2017
    If you click on the first date, then hover over the lower right corner, you should see a +. When you see that +, then click, HOLD, and scroll down until you have 12/31/2018 (I think that would be line 367). Let me know if that works.
     
    Andreea&Tilica likes this.
  3. Andreea&Tilica

    Andreea&Tilica Member

    Joined:
    Jan 25, 2017
    The problem is that I do not manage to set the desired format : day / month / year . That's why when I scroll down it appears a wrong date. You can take a look to see the error.
     
  4. Mandy & Rex (GA)

    Mandy & Rex (GA) Well-Known Member

    Joined:
    Mar 22, 2017
    Delete all but the first date. Then select that field to use as a default.

    I see you use a different format. Let me check to see how I can figure that out for you!
     
  5. Andreea&Tilica

    Andreea&Tilica Member

    Joined:
    Jan 25, 2017
    It works but it still doesn't take the format what I want. From the Format meniu I choose Number , More formats, More date ann tie formats. After I cutomize the date but it doesn't work...
     
  6. Mandy & Rex (GA)

    Mandy & Rex (GA) Well-Known Member

    Joined:
    Mar 22, 2017
    You need to highlight the entire column before doing the date formatting.
     
    Andreea&Tilica likes this.
  7. Marje and Gracie

    Marje and Gracie Senior Member Moderator

    Joined:
    May 30, 2010
    Please send me a PM and I’ll do it for you. There’s a method that can be a pain.
     
  8. Andreea&Tilica

    Andreea&Tilica Member

    Joined:
    Jan 25, 2017
    I I think I've managed to set the format,but but I can not remove the color from column.
    @Marje and Gracie I'll sent my password.
     
  9. Mandy & Rex (GA)

    Mandy & Rex (GA) Well-Known Member

    Joined:
    Mar 22, 2017
    So close!! Marje will get it all fixed for you!
     
    Andreea&Tilica likes this.
  10. Andreea&Tilica

    Andreea&Tilica Member

    Joined:
    Jan 25, 2017
    Thanks, for support.
     
  11. Kako & Tux

    Kako & Tux Well-Known Member

    Joined:
    Apr 24, 2016
    OMG! I copied all dates from the 2017 sheet, and pasted on the 2018 sheet. Then manually changed to 8 from 7. :blackeye:
    I will remember this next year. :joyful:
     
  12. Andreea&Tilica

    Andreea&Tilica Member

    Joined:
    Jan 25, 2017
    Wow , a lot of work:D. veru funny!
     
    Kako & Tux likes this.
  13. Kako & Tux

    Kako & Tux Well-Known Member

    Joined:
    Apr 24, 2016
    Oh yes, I spent hours doing this on New Year's Eve. :joyful::joyful::joyful:
     
    Andreea&Tilica likes this.
  14. Marje and Gracie

    Marje and Gracie Senior Member Moderator

    Joined:
    May 30, 2010
    You can always ask me for help. It literally takes me 10 seconds to do.

    Fixed. Good job doing the formatting.
     
    Andreea&Tilica and Kako & Tux like this.
  15. Andreea&Tilica

    Andreea&Tilica Member

    Joined:
    Jan 25, 2017
    Thanks a lot!:bighug:
     
  16. Marje and Gracie

    Marje and Gracie Senior Member Moderator

    Joined:
    May 30, 2010
    You’re welcome!
     
Thread Status:
Not open for further replies.

Share This Page