Number format
 

Hello
Can anyone help on this small query.
I want to enter a year in a cell in this format "2006/07"
I have several cells linked to this which will then populate in steps
i.e. based on the year I have entered they will increase annually thus
2007/08, 2008/09 et seq.
Can this be done?

Many thanks

Mars

Number format
 

There may be easier ways to do this but..........

With 2007 in A1

Enter in B1 =LEFT(A1,2)&RIGHT(A1,2)&"/"&TEXT(RIGHT(A1,2)+1,"00")


Gord Dibben MS Excel MVP


On Wed, 12 May 2010 11:47:45 -0700 (PDT), mars
wrote:

Hello
Can anyone help on this small query.
I want to enter a year in a cell in this format "2006/07"
I have several cells linked to this which will then populate in steps
i.e. based on the year I have entered they will increase annually thus
2007/08, 2008/09 et seq.
Can this be done?

Many thanks

Mars

Number format
 

Thanks Gord worked beautifully

Mars

Number format
 

Thanks for the feedback.

Gord

On Wed, 12 May 2010 14:20:00 -0700 (PDT), mars
wrote:

Thanks Gord worked beautifully

Mars

Number format
 

On 12 Mai, 21:15, Gord Dibben <gorddibbATshawDOTca wrote:
There may be easier ways to do this but..........

With 2007 in A1

Enter in B1 * =LEFT(A1,2)&RIGHT(A1,2)&"/"&TEXT(RIGHT(A1,2)+1,"00")

Gord Dibben *MS Excel MVP

On Wed, 12 May 2010 11:47:45 -0700 (PDT), mars
wrote:

Hello
Can anyone help on this small query.
I want to enter a year in a cell in this format "2006/07"
I have several cells linked to this which will then populate in steps
i.e. based on the year I have entered they will increase annually thus
2007/08, 2008/09 et seq.
Can this be done?

Many thanks

Mars

Try 1999 or 2099.
=LEFT(A1,2)&RIGHT(A1,2)&"/"&TEXT(RIGHT(RIGHT(A1,2)+1,2),"00")

Regards,
Bernd

Number format
 

Thank you Bernd - your solution was ace too.
Can you (or Gord) indulge me one more time please?
If I enter the year as before 2007/08 into A1 I would like the formula
in C2 to read 01/01/2008 (always showing January of the latter year.
Is this possible?

Kind Regards

Mars