Thread: Number format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mars[_2_] mars[_2_] is offline
external usenet poster
 
Posts: 3
Default 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