Why bother changing it to the first of the month?
--
David Biddulph

"Yanick" wrote in message
...
On Jan 14, 12:12 pm, jcontrer
wrote:
I have a column in which the date is entered in mm/dd/yyyy format.
what i would like to have is another column that takes that information
and
gives me the month in word format and the year in number format.

so for example:
if e2= 05/07/2009
i would like to have f2= May 2009

is that possible? if so, How do I do that?
your help will be greatly appreciated
--
thanks in advance

Use this formula : =Date(year(e2),month(e2),1)

Only need to change the cell format to display the right date format.