Hi,

I've got a whole list of dates which I've used an &"/".... formula to
create, but having pasted them as values, they've all aligned themselves left
& are not picking up as dates in subsequent formulas. I've set the format of
the cells to dd/mm/yyyy, but until I activate each cell (F2), it doesn't
convert.
Is there a way of sorting this out without having to press F2 for every cell?

Thanks
merry_fay