date display cell format

  1. B

    Q: Date Range formatting and DATEVALUE

    Hello all, I am sad to say I'm at wits end on this one. I automate my spreadsheets as much as possible and this one seems simple yet keeps escaping me. I have two sheets, Sheet1 has a date range and the Sheet2 has a header that needs to display the range of dates from the first sheet (ie...
  2. B

    displaying dates

    dear forum. i got a huge amount of dates within this format "5/31/2002". i use a german (speaking) keyboard plus operating system. This is why i would need the dates in this format "31.05.2002". Whenever i try to change the format (CTRL + 1) of the cell, f.e. customied or date, there is no...

Some videos you may like

This Week's Hot Topics