Convert Text to Date Month and Year

E

Excellency

Hi

I have a cell for example that displays 03/07 as a text field for month and
year. I want it converted to date field to display as = mar-07 or march 2007.
when I use format or text function it converts to 03/07/2010. I dont want to
have the current year display instead it should display 2007.
 
F

Fred Smith

Use:
=date(right(a1,2),left(a1,2),1)
and format as: mmm-yy or mmmm yyyy

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template with fields and premade texts.. 0
Creating a Search using a combo box and then creating a report. 4
Convert Date in Text to month and Year 3
how do i get excel to read 03/07 as March 2006 instead of 03 Jul? 3
convert number to date in excel 2003 2
Converting Date 03/01/2010 into a simple Month 8
(month) 2 digits in formula 5
Excel date question 0

Top