|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2010, 07:47 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
May 12th, 2010, 09:15 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#3
May 12th, 2010, 10:20 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number format
Thanks Gord worked beautifully
Mars
|
|
#4
May 12th, 2010, 10:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number format
Thanks for the feedback.
Gord On Wed, 12 May 2010 14:20:00 -0700 (PDT), mars wrote: Thanks Gord worked beautifully Mars
|
|
#5
May 13th, 2010, 07:05 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#6
May 13th, 2010, 09:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
