changuing Date format

[BRIITO]

Need some help with this...
There is an sales management system in the company I work for, from were I have to get a report and export it to excel to manipulate.
This report shows dates in cells with in the format YYYYMMDD (example cell A1 = 20100611).
I want to know if there is a formula or combination of formulas I can use to change the order of the numbers to the format dd-mmm-yy in an adjecent cell (B1 for example).
Right now I have a data base with all the dates of the year and use vlookp to change the formula....is there another way to do it that does not involve having to link 2 diff workbooks??

Hope I made myself clear...

Thanks a lot!!

 

[sulakvea]

u can easily do it by extracting left / right / mid parts and then use VALUE to convert to numbers, or use these formulas
year =INT(A1/10000)
month =INT(MOD(A1,10000)/100)
day =MOD(A1,100)

P.S. i misunderstood u i think. this is it:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

and format the cell from Custom Format to dd-mm-yy

 

[BRIITO]

Great thanks!!!