ExGrunt, thanks for that! It seems that you found the exact problem we were suffering from! I hadn't realised that that specific difference existed between the Excel versions!
I sent Capt BK an excel sheet via e-mail last night and that worked, but it must have converted the semi-colons to commas automatically.
Some of the other tips above look promising as well, at least they look simpler than my solution!