Formatting numbers

[Andrea]

I am trying to select a series of years for the X axis (e.g. 98-00, 99-01,
00-03, etc.). What format category should I choose for the cells, so that
"01-03" doesn't show up as "38355"? All of the other cells show-up correctly
when formatted as "number." I went down the list and tried each category, to
no avail.

Thank you.

 

[Ed Ferrero]

Hi Andrea,

To change dates to financial years, use a formula like
=IF(MONTH(A1)<7,TEXT(A1,"yy")-1&"-"&TEXT(A1,"yy"),TEXT(A1,"yy")&"-"&TEXT(A1,"yy")+1)

Ed Ferrero
http://edferrero.m6.net