Change Calendar Year to Financial Year

kimgourlay · May 2nd, 2002, 06:55 PM

I am trying to find out if there is a way to get Excel to recognise a financial year instead of the calendar year.

The answers that I've come up with so far are:
- Start the autofill with the first month
of the financial year
- Create my own autofill list

Any other suggestions?

Qroozn · May 2nd, 2002, 07:05 PM

customise your own list in excel. I'm just trying to remember how to add your own.

Qroozn · May 2nd, 2002, 07:06 PM

Tools/options/custom lists.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 06:55 PM	#1
kimgourlay New Member Join Date: May 2002 Posts: 1	I am trying to find out if there is a way to get Excel to recognise a financial year instead of the calendar year. The answers that I've come up with so far are: - Start the autofill with the first month of the financial year - Create my own autofill list Any other suggestions?

May 2nd, 2002, 07:05 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	customise your own list in excel. I'm just trying to remember how to add your own.

May 2nd, 2002, 07:06 PM	#3
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	Tools/options/custom lists.