Enter date series

The UK's most regular instructor-led training courses.
Training information: excel in courses · Excel in courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Enter date series

Sijin has attended:
Excel Introduction course

by - delegate Sijin [1 post] (2008 Apr 30 Wed, 15:36) Reply

when calculating CAGR, how to enter whole years

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 May 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jun 5 Thu + 6 Fri	Bayswater	6	book now	£450	£485
2003/XP	2008 Jun 12 Thu + 13 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Jun 19 Thu + 20 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jul 3 Thu + 4 Fri	Southwark	6	book now	£450	£485
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	5	book now	£450	£485
Full Schedule: See all 65 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: enter date series

by - trainer Tracy platinum contributer [586 posts] (2008 May 9 Fri, 05:29) Reply

Hi Sijin,

Have you tried going to Format>Cells>go to the Number tab and down to the Custom option and in the box that says"Type" type in either "yy" or "yyyy" for 08 or 2008 respectively.

I hope that helps

Tracy

· How to Create Better Excel Spreadsheets: Part Four
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Microsoft Excel Training: Not Just for Newbies Anymore
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Training Course

Please browse our web site to find out more about
excel in courses and other Microsoft training courses.