Forum home » Delegate support and help forum » Microsoft Excel Training and help » Enter date series
Enter date series
Resolved · Low Priority · Version 2003
Sijin has attended:
Excel Introduction course
Enter date series
when calculating CAGR, how to enter whole years
For upcoming training course dates see: Pricing & availability
RE: enter date series
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
|
