Prev: how to delete name:1 xxxx:2
Next: Transpose a table
From: Doug Muegge on 19 Jan 2010 11:21
I would like to change the underlying date format from e.g. 01-May-09 to
May-09. I can change the format so that the displayed date is in correct
format but the underlying date is still in DD/MM/YYYY format. The purpose is
to do pivot charts to show how many defects per month over the last five
years.
--
Doug M
From: Gary''s Student on 19 Jan 2010 11:28
Rather than reformat the cell to Custom > mmm-yy

use something like:

=TEXT(A1,"mmm-yy")

--
Gary''s Student - gsnu200909


"Doug Muegge" wrote:

> I would like to change the underlying date format from e.g. 01-May-09 to
> May-09. I can change the format so that the displayed date is in correct
> format but the underlying date is still in DD/MM/YYYY format. The purpose is
> to do pivot charts to show how many defects per month over the last five
> years.
> --
> Doug M
From: Doug Muegge on 19 Jan 2010 13:09
This solution worked perfectly - Thank you - saved me considerable time!!!
--
Doug M


"Doug Muegge" wrote:

> I would like to change the underlying date format from e.g. 01-May-09 to
> May-09. I can change the format so that the displayed date is in correct
> format but the underlying date is still in DD/MM/YYYY format. The purpose is
> to do pivot charts to show how many defects per month over the last five
> years.
> --
> Doug M
 | 
Pages: 1
Prev: how to delete name:1 xxxx:2
Next: Transpose a table