I have got date format as "12082010".how to convert that in dd-mm-yyyy.

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.

Thnks for the reply it wrks.