Change the date format

[Kohli]

I have date field like 

Date

200507

210507

310507

100308

250508

I want convert into date format like 

20-05-2007

25-05-2007

[shiveshsingh]

Hi

Try this

=DATE(date#(200507,'DDMMYY'),'DD-MM-YYYY')

[jobsonkjoseph]

Hi, Small correction to the response, try =DATE(date#(Date,'DDMMYY'),'DD-MM-YYYY')

[sasis551]

Hi ,

Date#-interpretation function

Date-Formatting function

=DATE(date#(Date,'DDMMYY'),'DD-MM-YYYY')