On Thu, 6 May 2010 12:12:01 -0700, LovingLife28
wrote:

I need to update a list of dates to show all days as 01. For example, where
date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any
guidance!


If you want to convert the dates to the first of the month, then, with your
date in A1:

=A1-DAY(A1)+1

If you want to leave the date as is, but merely have display as mm/01/yyyy

Then custom format: mm"/01/"yyyy

--ron