pat2068 23:04 23 Jun 2004

does anyone know of a program that will let you change months like jan to feb when you reach the 31st of the month with just the enter key i want it for accounts thanks leo

  pat2068 23:22 23 Jun 2004


  VoG II 09:34 25 Jun 2004

Can you explain *exactly* what you are trying to achieve, please?

  Jakey boy 09:38 25 Jun 2004
  pat2068 18:53 25 Jun 2004

i do accounts and i want a program that will change from month to month when you press enter
when you reach the 31 jan and press enter i would like it to change to feb and so on with all the dates down the left hand side leo

  VoG II 18:59 25 Jun 2004

In Excel, write a date in A1 and press the Enter key.

(for example 1-jan-2004).

Hover the cursor over the bottom right of A1 and the cursor should turn into a +

Hold down the left mouse button and drag the mouse down the page and Excel will automatically add consecutive dates for you. Release the mouse button when you have sufficient.

When you need more dates down the left hand side follow the same procedure and Excel will add more.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?