Date to Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to change a date into text.

Cell A1 - 03/14/2007

I would like to change that value to March 2007, and I don't mean by
changing the format of the cell. I want the value to be March 2007.
 
Hi

I think you'll need a helper column with:

=TEXT(A1,"mmmm yyyy")

copied down, and then copy and paste values back into your original
column.

There would be VBA solutions in addition.

Hope this helps!

Richard
 
You must log in or register to reply here.

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

Extracting dates from a String 8
Searching the formula (not the value) for a text string 1
Finding a date range from given date 1
Adding days to a date - changed in Excel 2010 8
Rolling Formula based on If 2
How do i combine 2 cells contain date in one cell, 2
Conditional formatting by day of the date in Excel 2003 7
Stop automatic formatting of cells (number, text, date, etc) 4

Back
Top