If those values are in a single column, you can use:
Data|Text to columns|fixed width (but don't draw any lines)
and choose ymd as the date format.

After you finish that step, you can apply the date format you want to make it
look pretty.

If you have multiple columns, you have to do each separately.

Morgs wrote:

SO I know all about using the custom option in format cells, but this only
works if I have something in a format excel recognizes, right?

I have lists of dates printed out in yyyymmdd format, and I want that to be
converted to dd/mm/yyyy. How do I do this?

Thanks,
Morgs

--

Dave Peterson