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.
Thanking you for taking the time to read this post and for any and all help you can provide.
8/29/2011 to 2011.08.29
Last edited by artiststevens; 08-29-2011 at 06:10 AM.
Enter date normally and then right click, format cells as yyyy.mm.dd
Never use Merged Cells in Excel
Hey Zbor,
Is this under format special or custom? I don't see this option. Thanks for the help.
I figured it out. Thanks for the help!
Custom -> Type: yyyy.mm.dd
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks