Problems converting date from d/m/yyyy to mmmm format

**dcgrove** · 07-22-2009, 11:07 AM

Hello, I am having some issues converting the dates in column A on the attached spreadsheet to the mmmm format. I cannot get the dates to change format at all so I was hoping someone might have some ideas why. I have tried everything I can think of. The only thing that has worked so far has been to retype the date in the cells. I have 32000 rows of data I have to convert.

Thanks!
Clayton

**contaminated** · 07-22-2009, 11:24 AM

because they are stored as text

**dcgrove** · 07-22-2009, 11:28 AM

How do I convert them from text to numbers?

**contaminated** · 07-22-2009, 11:46 AM

This function converts 'em to a normal dates

Please Login or Register  to view this content.

**shg** · 07-22-2009, 11:49 AM

Or, you can select the column, and do ...

Data > Text to columns, tick Delimited, Next, Next, and under Column data format, select Date, MDY, Finish

**dcgrove** · 07-22-2009, 11:52 AM

contaminated that formula returned a #Value error, but I appreciate you trying to help!

SHG, the text to columns worked! thanks!

**sighlent1** · 07-22-2009, 01:25 PM

ignore this msg...i just gotta try something

Problems converting date from d/m/yyyy to mmmm format

LinkBack

Thread Tools

Rate This Thread

Display

Problems converting date from d/m/yyyy to mmmm format

Re: Problems converting date from d/m/yyyy to mmmm format

Re: Problems converting date from d/m/yyyy to mmmm format

Re: Problems converting date from d/m/yyyy to mmmm format

Re: Problems converting date from d/m/yyyy to mmmm format

Re: Problems converting date from d/m/yyyy to mmmm format

Re: Problems converting date from d/m/yyyy to mmmm format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions