I almost discovered the problem. Some of the data (coordinates) that I copied in had spaces in between the values (ie 3 050 236.365). When I took the spaces out and replaced the comma with a full stop then the equations worked.

But now my next question is how to avoid this problem by automatically copying the data from another source (ie a text file) into excel without the values having spaces between them?