Converting Dates

I ahve a spreadsheet with several thousand rows of information. Column A of
the spreadsheet contains a date reference as follows:

A
1 1/12/93
2 1/17/93
3 2/5/94
4 12/12/03

I want to use a pivot table to report this information by month and by year.
I would like to change the date reference in each of the rows in Column A so
that the day of the month reference would be 1. The above cells would now
look as follows:

A
1 1/1/93
2 1/1/93
3 2/1/94
4 12/1/03


How can I easily accomplish this?

Use a helper column and put this and copy down....then Copy > PasteSpecial >
Values on that column to emiminate the formulas

=DATE(YEAR(A1),MONTH(A1),1)

Vaya con Dios,
Chuck, CABGx3



"Mike" wrote:

> I ahve a spreadsheet with several thousand rows of information. Column A of
> the spreadsheet contains a date reference as follows:
>
> A
> 1 1/12/93
> 2 1/17/93
> 3 2/5/94
> 4 12/12/03
>
> I want to use a pivot table to report this information by month and by year.
> I would like to change the date reference in each of the rows in Column A so
> that the day of the month reference would be 1. The above cells would now
> look as follows:
>
> A
> 1 1/1/93
> 2 1/1/93
> 3 2/1/94
> 4 12/1/03
>
>
> How can I easily accomplish this?
>
>
>

Thanks.

"CLR" wrote:

> Use a helper column and put this and copy down....then Copy > PasteSpecial >
> Values on that column to emiminate the formulas
>
> =DATE(YEAR(A1),MONTH(A1),1)
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Mike" wrote:
>
> > I ahve a spreadsheet with several thousand rows of information. Column A of
> > the spreadsheet contains a date reference as follows:
> >
> > A
> > 1 1/12/93
> > 2 1/17/93
> > 3 2/5/94
> > 4 12/12/03
> >
> > I want to use a pivot table to report this information by month and by year.
> > I would like to change the date reference in each of the rows in Column A so
> > that the day of the month reference would be 1. The above cells would now
> > look as follows:
> >
> > A
> > 1 1/1/93
> > 2 1/1/93
> > 3 2/1/94
> > 4 12/1/03
> >
> >
> > How can I easily accomplish this?
> >
> >
> >