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

    Sep 21, 2012, 03:58 AM
    Date conversion
    I have got date format as "12082010".how to convert that in dd-mm-yyyy.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Sep 21, 2012, 04:46 AM
    First, its not a good idea to piggyback your question on another thread. To avoid confusion your question has been moved to its own thread.

    Assuming that format is mmddyyyy, you can use the Left, Mid and Right functions along with the Date function to parse the date:

    =DATE(RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))

    where A1 is the cell where the4 date string is.
    aks0611's Avatar
    aks0611 Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Sep 21, 2012, 05:19 AM
    Thnks for the reply it wrks.
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!

Date converter english date to tibetan date [ 1 Answers ]

How to convert english date to tibetan date

Date Conversion [ 1 Answers ]

Hi everybody I just wanted to know how to convert Hijri date in a column in Excel2007 into Gregorian?

Outlook Express to Outlook conversion gave messages wrong "Date Received." [ 1 Answers ]

Hi, All! I used Outlook's Import capbility to import everything from Outlook Express: mail settings, folders, their messages, etc. The import process reported successful import of my huge sets of folders, subfolders and their 11,000+ messages... however: The Good: Some messages were...

View more questions Search