Thread: 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" <Andrea@discussions.microsoft.com> wrote in message
news:4DD525AB-C653-4C33-BB59-1165F8A4AD24@microsoft.com...
>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