Hi I want to copy & drag financial years out to a number of years eg. 10. Is
there a way using the drag handlebar or do i have to enter a formula?

For example in column A, first cell I put:

2009-10

I want to be able to drag it to make 2010-11 but when i drag and copy it
makes it 2009-11 (it seems to only recognise the last digit).

Any help would be appreciated.