Ask Experts Questions for FREE Help !
Ask
    GCabana's Avatar
    GCabana Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jul 30, 2012, 11:47 AM
    Convert dates
    I have a string of number in the following format: 2012.07.11
    How can I convert this into a date format like you have above?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jul 30, 2012, 12:18 PM
    =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

    Where A1 contains your date string.

    P.s. Its not a good idea to piggyback your question on another thread. To avoid confusion I've moved your post to its own thread.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    Jul 30, 2012, 05:48 PM
    You "might" have success if you just highlight the cells in question, press CTRL-H (replace) and do a search for period and replace them with slashes.

    2012-07-30_1747 - JerryBeaucaire's library
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Reconciling with the dates on the payment receipts with the posted dates on statement [ 0 Answers ]

I pay a monthly assessment fee to my homeowners association. I always pay in person and obtain a dated receipt for my payment, but on two of the monthly statements, my payments were posted days after the dates on my receipts of payment. This resulted in being charged for a late fee on one and on...

What do you do when you like your ex again and he dates some else [ 1 Answers ]

My ex and I recently broke up and now I like him again. He just started dating my friend not knowing that she was my friend. Help! What should I do?

How to convert jpg image file convert into word file [ 1 Answers ]

Kindly give me suggestion

Convert english dates into tibetan caledar [ 1 Answers ]

I need to know what the date 05/24/1988 looks like in the Tibetan Calendar... if anyone could help, that'd be fantastic!

Do doctors make mistakes about conception dates and due dates? [ 3 Answers ]

I don't understand, can doctors be wrong about conception dates and due dates?

View more questions Search