Convert Date - 8/29/2011 to 2011.08.29

**artiststevens** · 08-29-2011, 05:35 AM

Hello,
Can anyone help me with a creating a formula that would change the following date format? I attempted to make the changes with Excel's date format but it doesn't recognize the dates. I'm thinking a substitute formula would work best but I'm not sure. Below is an example of how I want to convert the date.

Please Login or Register  to view this content.

Thanking you for taking the time to read this post and for any and all help you can provide.

**zbor** · 08-29-2011, 05:44 AM

Enter date normally and then right click, format cells as yyyy.mm.dd

**artiststevens** · 08-29-2011, 06:09 AM

Hey Zbor,
Is this under format special or custom? I don't see this option. Thanks for the help.

**artiststevens** · 08-29-2011, 06:10 AM

I figured it out. Thanks for the help!

**zbor** · 08-29-2011, 06:10 AM

Custom -> Type: yyyy.mm.dd

Convert Date - 8/29/2011 to 2011.08.29

LinkBack

Thread Tools

Rate This Thread

Display

Convert Date - 8/29/2011 to 2011.08.29

Re: Convert Date - 8/29/2011 to 2011.08.29

Re: Convert Date - 8/29/2011 to 2011.08.29

Re: Convert Date - 8/29/2011 to 2011.08.29

Re: Convert Date - 8/29/2011 to 2011.08.29

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions