convert date to different format

's Computer Specifications

I have data in columns A through P and in column C I have dates in the format
YYYYMMDD and I need the format MMDDYYYY. I only have one worksheet in this
file. Can anyone help me with this? susan

's Computer Specifications

Hi,

Select column C dates then

Format|Cells - Custom

enter a custom format of MMDDYYYY

Mike

"ILoveMyCorgi" wrote:

> I have data in columns A through P and in column C I have dates in the format
> YYYYMMDD and I need the format MMDDYYYY. I only have one worksheet in this
> file. Can anyone help me with this? susan

's Computer Specifications

Thanks. I tried that and the result is ######### all the way across the
fields no matter how much I shrink or stretch that column.

"ILoveMyCorgi" wrote:

> I have data in columns A through P and in column C I have dates in the format
> YYYYMMDD and I need the format MMDDYYYY. I only have one worksheet in this
> file. Can anyone help me with this? susan

's Computer Specifications

When you say you have "dates in the format YYYYMMDD", do you mean you have *real* date values in cells that have been Cell Formatted to look like "YYYYMMDD", or do you mean you have "YYYYMMDD" looking text strings (that is, not *real* dates)? If you have *real* dates, then just use cell formatting to make them look like you want. If they are just text strings, then try this formula...

=TEXT(--TEXT(A1,"0000-00-00"),"mmddyyyy")

--
Rick (MVP - Excel)

"ILoveMyCorgi" <(E-Mail Removed)> wrote in message news:A4B60096-DAEA-4437-AC65-(E-Mail Removed)...
>I have data in columns A through P and in column C I have dates in the format
> YYYYMMDD and I need the format MMDDYYYY. I only have one worksheet in this
> file. Can anyone help me with this? susan

's Computer Specifications

Thanks! That worked beautifully. I had actually real dates that were
extracted from a database and I needed to import the data into a database
that will only accept the MMDDYYYY format. Thanks so much for helping me.
Susan

"Rick Rothstein" wrote:

> When you say you have "dates in the format YYYYMMDD", do you mean you have *real* date values in cells that have been Cell Formatted to look like "YYYYMMDD", or do you mean you have "YYYYMMDD" looking text strings (that is, not *real* dates)? If you have *real* dates, then just use cell formatting to make them look like you want. If they are just text strings, then try this formula...
>
> =TEXT(--TEXT(A1,"0000-00-00"),"mmddyyyy")
>
> --
> Rick (MVP - Excel)
>
>
> "ILoveMyCorgi" <(E-Mail Removed)> wrote in message news:A4B60096-DAEA-4437-AC65-(E-Mail Removed)...
> >I have data in columns A through P and in column C I have dates in the format
> > YYYYMMDD and I need the format MMDDYYYY. I only have one worksheet in this
> > file. Can anyone help me with this? susan
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I convert dd/mm/yy date format to yyddd Julian date format	itzy bitzy	Microsoft Excel Worksheet Functions	7	11th Dec 2009 03:20 AM
Convert european foreign date format to US date format	EAL	Microsoft Excel Worksheet Functions	2	14th May 2009 10:02 PM
Convert european foreign date format to US date format	EAL	Microsoft Excel Worksheet Functions	0	14th May 2009 09:38 PM
Convert date + time text format to date format	=?Utf-8?B?UGF1bCBIbw==?=	Microsoft Excel Worksheet Functions	2	22nd May 2007 05:47 PM
code to convert date from TEXT format (03-02) to DATE format (200203)	Gauthier	Microsoft Excel Programming	0	22nd Sep 2004 03:26 PM