I have tried various suggestions to change this format to date only (I want YYYY-MM-DD). Here is the current format: 2014-09-04T01:30:01+0000. If i try to reformat the cell, it defaults to the date selections (ie. not text or general), but no matter what I chose, it does not help me achieve YYYY-MM-DD. Any help appreciated.
In Excel, 2014-09-04T01:30:01+0000 is just a TEXT string.
If you want to format it to display the date you'll have to extract the date to another cell.
A1 = 2014-09-04T01:30:01+0000
Enter this formula in B1:
=--LEFT(A1,10)
Then you can format in the date style of your choice.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
It works! Thank you so much
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
OK - I am really hopeless - I cannot figure out how to mark post as SOLVED!! Can you help me again??
In the menu bar at the top of the page above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks