Does anyone know EXACTLY what format MapPoint wants when entering a UK OS grid reference (in importing data)???
I know it has to be a single string like "205988 561299".
But it seems to want leading zeroes if there are less digits? e.g. "089315 013360"
And if in Northern Scotland just add the "1"? e.g. "440530 1110105"
I'm trying to figure out a format that I can tell Excel to use that will import but I always end up massaging the numbers by hand.