Formatting numbers
 

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.
--
Andrea

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

"Andrea" wrote in message
...
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.
--
Andrea