When I try to perform a mail merge from excel to word, the excel cells have
the correct format, eg. decimal places, % and $ signs. When I conduct the
merge, I lose the % and $ signs, and numbers are blown out to ~ 15 decimal
places.

This did not occure with Office 2000. I'm sure I just need to tick a format
box or something but I don't know where?