another way.

Select your column
Data\Text to colums|Fixed width|date|YMD
Finish

Mike

"Junderwood57" wrote:

I'm creating a very large spreadsheet and have a question, with hopefully a
simple solution. The dates that pulled into Exel are formatted as 20070529.
There are over 1500 lines with dates this way and all different dates. How
do I chnage these dates to format as a regular 05/07/2007? the format cell
function does not work and to manually change would take quite a while. I'm
not sure if there is a way to paste special? Anyone's help would be
appreciated.
Thanks!