I receive date data in yyyymmdd format eg, 20061031 = 31 Oct 2006.
I want to transpose the data to dd-mm-yyyy format.
Prefer not to use VBA.
I thought I had seen an in cell format using the text() & mid() expressions
but cannot reproduce it.

Tks